PREVIEW / stock_30min / 2018-12-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-06.parquet
  size:    1.8 MB
  rows:    88,344
  symbols: 2,758

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2018-12-06 04:00:00	AAPL	Stock	43.5	43.5	43.0475	43.05	33400.0
2018-12-06 04:30:00	AAPL	Stock	43.05	43.1225	42.8075	42.8075	38688.0
2018-12-06 05:00:00	AAPL	Stock	42.865	42.945	42.7875	42.85	17836.0
2018-12-06 05:30:00	AAPL	Stock	42.795	43.15	42.795	42.9725	159684.0
2018-12-06 06:00:00	AAPL	Stock	42.975	43.15	42.975	43.1025	21232.0
2018-12-06 06:30:00	AAPL	Stock	43.1125	43.15	42.92	43.07	29016.0
2018-12-06 07:00:00	AAPL	Stock	43.08	43.205	43.0	43.1225	538476.0
2018-12-06 07:30:00	AAPL	Stock	43.05	43.1725	42.9325	43.0925	343624.0
2018-12-06 08:00:00	AAPL	Stock	43.0725	43.29	42.9675	43.2175	606592.0
2018-12-06 08:30:00	AAPL	Stock	43.2	43.26	43.04	43.05	472748.0
2018-12-06 09:00:00	AAPL	Stock	43.05	43.0875	42.88	42.96	646472.0
2018-12-06 09:30:00	AAPL	Stock	42.9575	43.2325	42.655	42.8275	28709444.0
2018-12-06 10:00:00	AAPL	Stock	42.83	43.0475	42.7358	42.935	15620500.0
2018-12-06 10:30:00	AAPL	Stock	42.94	43.0375	42.7175	42.808	11994420.0
2018-12-06 11:00:00	AAPL	Stock	42.805	42.865	42.605	42.68	11972144.0
2018-12-06 11:30:00	AAPL	Stock	42.671	43.1175	42.655	43.1102	10140472.0
2018-12-06 12:00:00	AAPL	Stock	43.1105	43.3875	42.9075	43.3632	7886756.0
2018-12-06 12:30:00	AAPL	Stock	43.365	43.59	43.2975	43.42	7144120.0
2018-12-06 13:00:00	AAPL	Stock	43.4175	43.42	43.1075	43.135	5547496.0
2018-12-06 13:30:00	AAPL	Stock	43.13	43.47	43.0125	43.45	5323532.0
2018-12-06 14:00:00	AAPL	Stock	43.4457	43.5225	43.0625	43.3013	6127508.0
2018-12-06 14:30:00	AAPL	Stock	43.3002	43.36	43.0375	43.2978	5014624.0
2018-12-06 15:00:00	AAPL	Stock	43.3	43.4098	43.1875	43.3275	5311576.0
2018-12-06 15:30:00	AAPL	Stock	43.3225	43.695	43.2975	43.69	12854032.0
2018-12-06 16:00:00	AAPL	Stock	43.69	43.7	43.5097	43.6225	12435228.0
2018-12-06 16:30:00	AAPL	Stock	43.66	43.7	43.625	43.69	140980.0
2018-12-06 17:00:00	AAPL	Stock	43.7	43.74	43.68	43.74	40132.0
2018-12-06 17:30:00	AAPL	Stock	43.74	43.765	43.7275	43.735	35608.0
2018-12-06 18:00:00	AAPL	Stock	43.75	43.775	43.655	43.75	46840.0
2018-12-06 18:30:00	AAPL	Stock	43.75	43.8125	43.725	43.8	52352.0
2018-12-06 19:00:00	AAPL	Stock	43.8375	43.84	43.7375	43.75	53452.0
2018-12-06 19:30:00	AAPL	Stock	43.7625	43.79	43.72	43.75	54552.0
2018-12-06 04:00:00	MSFT	Stock	107.5	107.5	106.6	106.6	3407.0
2018-12-06 04:30:00	MSFT	Stock	106.6	106.6	106.0	106.0	3400.0
2018-12-06 05:00:00	MSFT	Stock	105.93	106.38	105.93	106.38	1133.0
2018-12-06 05:30:00	MSFT	Stock	106.0	106.0	106.0	106.0	1819.0
2018-12-06 06:00:00	MSFT	Stock	106.02	106.02	106.02	106.02	200.0
2018-12-06 06:30:00	MSFT	Stock	106.4	106.4	105.9	106.16	8606.0
2018-12-06 07:00:00	MSFT	Stock	106.64	106.73	106.2	106.41	8191.0
2018-12-06 07:30:00	MSFT	Stock	106.5	106.73	106.21	106.73	14400.0
2018-12-06 08:00:00	MSFT	Stock	106.5	107.39	106.15	107.0	24586.0
2018-12-06 08:30:00	MSFT	Stock	106.8	106.93	106.62	106.62	15002.0
2018-12-06 09:00:00	MSFT	Stock	106.61	106.67	105.9	105.9	45126.0
2018-12-06 09:30:00	MSFT	Stock	105.91	107.51	105.0	106.39	6803209.0
2018-12-06 10:00:00	MSFT	Stock	106.39	106.99	106.12	106.72	3302135.0
2018-12-06 10:30:00	MSFT	Stock	106.73	106.945	105.92	106.0	3188529.0
2018-12-06 11:00:00	MSFT	Stock	105.99	106.359	105.37	105.505	3115809.0
2018-12-06 11:30:00	MSFT	Stock	105.5	107.02	105.41	107.005	2497418.0
2018-12-06 12:00:00	MSFT	Stock	107.0	107.89	106.6	107.85	2789189.0
2018-12-06 12:30:00	MSFT	Stock	107.86	108.32	107.56	107.987	1951083.0

> showing 50 of 88,344 rows — these rows as CSV

> unlock the full archive -- $79 one-time