PREVIEW / stock_30min / 2017-12-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-06.parquet
  size:    1.6 MB
  rows:    83,229
  symbols: 2,941

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
2017-12-06 04:00:00	AAPL	Stock	42.24	42.24	42.24	42.24	1496.0
2017-12-06 04:30:00	AAPL	Stock	42.25	42.25	42.25	42.25	400.0
2017-12-06 05:00:00	AAPL	Stock	42.235	42.235	42.2	42.2	6380.0
2017-12-06 05:30:00	AAPL	Stock	42.1875	42.1875	42.1825	42.1825	2800.0
2017-12-06 06:00:00	AAPL	Stock	42.1875	42.1875	42.14	42.1675	10864.0
2017-12-06 06:30:00	AAPL	Stock	42.235	42.235	42.1675	42.1675	4800.0
2017-12-06 07:00:00	AAPL	Stock	42.225	42.25	42.165	42.165	76296.0
2017-12-06 07:30:00	AAPL	Stock	42.165	42.2425	42.1625	42.1675	140980.0
2017-12-06 08:00:00	AAPL	Stock	42.19	42.25	41.9775	42.015	462992.0
2017-12-06 08:30:00	AAPL	Stock	42.025	42.0925	42.025	42.0875	197312.0
2017-12-06 09:00:00	AAPL	Stock	42.09	42.175	41.835	41.8475	801008.0
2017-12-06 09:30:00	AAPL	Stock	41.875	42.305	41.615	42.2825	25093108.0
2017-12-06 10:00:00	AAPL	Stock	42.2812	42.375	42.14	42.323	8459100.0
2017-12-06 10:30:00	AAPL	Stock	42.325	42.3725	42.1725	42.37	5892528.0
2017-12-06 11:00:00	AAPL	Stock	42.37	42.5513	42.295	42.365	6436220.0
2017-12-06 11:30:00	AAPL	Stock	42.365	42.465	42.3375	42.3925	4462636.0
2017-12-06 12:00:00	AAPL	Stock	42.3925	42.4625	42.225	42.265	4529700.0
2017-12-06 12:30:00	AAPL	Stock	42.265	42.425	42.2375	42.3175	4064716.0
2017-12-06 13:00:00	AAPL	Stock	42.3198	42.365	42.27	42.3275	2420632.0
2017-12-06 13:30:00	AAPL	Stock	42.3275	42.4175	42.32	42.39	2966644.0
2017-12-06 14:00:00	AAPL	Stock	42.39	42.5075	42.3395	42.345	4358208.0
2017-12-06 14:30:00	AAPL	Stock	42.3425	42.4075	42.305	42.33	3421904.0
2017-12-06 15:00:00	AAPL	Stock	42.3288	42.3625	42.235	42.27	5532252.0
2017-12-06 15:30:00	AAPL	Stock	42.2675	42.305	42.2075	42.2625	8591496.0
2017-12-06 16:00:00	AAPL	Stock	42.2525	42.3	42.2	42.2125	9223084.0
2017-12-06 16:30:00	AAPL	Stock	42.2125	42.2675	42.2	42.2075	85724.0
2017-12-06 17:00:00	AAPL	Stock	42.225	42.25	42.2125	42.225	33360.0
2017-12-06 17:30:00	AAPL	Stock	42.2625	42.2875	42.2625	42.2875	51356.0
2017-12-06 18:00:00	AAPL	Stock	42.285	42.285	42.2525	42.2675	17244.0
2017-12-06 18:30:00	AAPL	Stock	42.28	42.2875	42.26	42.28	23900.0
2017-12-06 19:00:00	AAPL	Stock	42.2825	42.3	42.2825	42.3	21232.0
2017-12-06 19:30:00	AAPL	Stock	42.29	42.355	42.29	42.355	52680.0
2017-12-06 06:00:00	MSFT	Stock	81.22	81.22	81.22	81.22	100.0
2017-12-06 06:30:00	MSFT	Stock	81.22	81.22	81.22	81.22	100.0
2017-12-06 07:00:00	MSFT	Stock	81.25	81.25	81.1	81.1	7584.0
2017-12-06 08:00:00	MSFT	Stock	81.1	81.34	81.06	81.32	7739.0
2017-12-06 08:30:00	MSFT	Stock	81.31	81.4	81.13	81.36	13130.0
2017-12-06 09:00:00	MSFT	Stock	81.3	81.89	81.25	81.64	23616.0
2017-12-06 09:30:00	MSFT	Stock	81.67	82.53	81.43	82.37	2239511.0
2017-12-06 10:00:00	MSFT	Stock	82.37	82.66	82.37	82.55	1424479.0
2017-12-06 10:30:00	MSFT	Stock	82.555	82.955	82.33	82.935	1371731.0
2017-12-06 11:00:00	MSFT	Stock	82.94	83.14	82.78	82.858	1747562.0
2017-12-06 11:30:00	MSFT	Stock	82.86	82.97	82.61	82.92	799575.0
2017-12-06 12:00:00	MSFT	Stock	82.92	82.98	82.615	82.62	806937.0
2017-12-06 12:30:00	MSFT	Stock	82.62	82.855	82.47	82.83	1024392.0
2017-12-06 13:00:00	MSFT	Stock	82.83	82.84	82.69	82.75	963656.0
2017-12-06 13:30:00	MSFT	Stock	82.745	82.85	82.65	82.775	1075176.0
2017-12-06 14:00:00	MSFT	Stock	82.77	82.99	82.713	82.81	943246.0
2017-12-06 14:30:00	MSFT	Stock	82.81	82.89	82.68	82.81	895515.0
2017-12-06 15:00:00	MSFT	Stock	82.81	82.92	82.69	82.72	1017900.0

> showing 50 of 83,229 rows — these rows as CSV

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