PREVIEW / stock_30min / 2015-03-05

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-05.parquet
  size:    1.6 MB
  rows:    82,092
  symbols: 3,494

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
2015-03-05 04:00:00	AAPL	Stock	32.165	32.22	32.165	32.2	7620.0
2015-03-05 04:30:00	AAPL	Stock	32.2	32.21	32.2	32.21	5200.0
2015-03-05 05:00:00	AAPL	Stock	32.1975	32.2	32.1975	32.1975	5600.0
2015-03-05 05:30:00	AAPL	Stock	32.2	32.2175	32.2	32.2175	5980.0
2015-03-05 06:00:00	AAPL	Stock	32.2175	32.2175	32.2125	32.2175	8400.0
2015-03-05 06:30:00	AAPL	Stock	32.2175	32.2325	32.2175	32.225	13808.0
2015-03-05 07:00:00	AAPL	Stock	32.2125	32.235	32.205	32.225	73660.0
2015-03-05 07:30:00	AAPL	Stock	32.2225	32.225	32.2025	32.2025	27148.0
2015-03-05 08:00:00	AAPL	Stock	32.205	32.245	32.135	32.22	383040.0
2015-03-05 08:30:00	AAPL	Stock	32.22	32.2475	32.1025	32.195	394156.0
2015-03-05 09:00:00	AAPL	Stock	32.175	32.1975	32.11	32.14	239676.0
2015-03-05 09:30:00	AAPL	Stock	32.145	32.1875	31.93	31.955	25257224.0
2015-03-05 10:00:00	AAPL	Stock	31.955	32.0	31.76	31.815	24143488.0
2015-03-05 10:30:00	AAPL	Stock	31.8125	31.8725	31.7525	31.78	16409960.0
2015-03-05 11:00:00	AAPL	Stock	31.7775	31.7925	31.5772	31.74	30502336.0
2015-03-05 11:30:00	AAPL	Stock	31.7425	31.785	31.665	31.735	11273936.0
2015-03-05 12:00:00	AAPL	Stock	31.735	31.7428	31.6402	31.6768	7435908.0
2015-03-05 12:30:00	AAPL	Stock	31.6775	31.6925	31.44	31.48	18634432.0
2015-03-05 13:00:00	AAPL	Stock	31.48	31.6125	31.4525	31.5985	11209512.0
2015-03-05 13:30:00	AAPL	Stock	31.5975	31.6075	31.525	31.585	6555544.0
2015-03-05 14:00:00	AAPL	Stock	31.58	31.72	31.58	31.6878	10086628.0
2015-03-05 14:30:00	AAPL	Stock	31.6875	31.7325	31.605	31.6775	10103544.0
2015-03-05 15:00:00	AAPL	Stock	31.6775	31.68	31.5638	31.6112	9693908.0
2015-03-05 15:30:00	AAPL	Stock	31.61	31.6325	31.535	31.6	18810372.0
2015-03-05 16:00:00	AAPL	Stock	31.6025	31.7722	31.565	31.5752	8013720.0
2015-03-05 16:30:00	AAPL	Stock	31.575	31.6025	31.5748	31.5748	458056.0
2015-03-05 17:00:00	AAPL	Stock	31.575	31.575	31.565	31.565	60520.0
2015-03-05 17:30:00	AAPL	Stock	31.6025	31.6025	31.5575	31.5625	116708.0
2015-03-05 18:00:00	AAPL	Stock	31.565	31.5725	31.55	31.5725	81268.0
2015-03-05 18:30:00	AAPL	Stock	31.575	31.6025	31.565	31.565	46644.0
2015-03-05 19:00:00	AAPL	Stock	31.575	31.575	31.5475	31.55	82760.0
2015-03-05 19:30:00	AAPL	Stock	31.5425	31.55	31.525	31.5375	136588.0
2015-03-05 08:00:00	MSFT	Stock	43.13	43.13	43.08	43.08	677.0
2015-03-05 08:30:00	MSFT	Stock	43.1	43.15	43.1	43.15	1700.0
2015-03-05 09:00:00	MSFT	Stock	43.1	43.11	43.07	43.08	51772.0
2015-03-05 09:30:00	MSFT	Stock	43.07	43.24	42.82	43.14	3499827.0
2015-03-05 10:00:00	MSFT	Stock	43.14	43.22	43.08	43.16	1403424.0
2015-03-05 10:30:00	MSFT	Stock	43.16	43.2	43.09	43.15	983305.0
2015-03-05 11:00:00	MSFT	Stock	43.14	43.2	43.09	43.125	1563723.0
2015-03-05 11:30:00	MSFT	Stock	43.125	43.19	43.11	43.14	933672.0
2015-03-05 12:00:00	MSFT	Stock	43.14	43.17	43.094	43.12	944221.0
2015-03-05 12:30:00	MSFT	Stock	43.115	43.18	43.025	43.095	1101152.0
2015-03-05 13:00:00	MSFT	Stock	43.09	43.12	43.03	43.07	794788.0
2015-03-05 13:30:00	MSFT	Stock	43.075	43.15	43.075	43.135	928292.0
2015-03-05 14:00:00	MSFT	Stock	43.14	43.19	43.12	43.123	664555.0
2015-03-05 14:30:00	MSFT	Stock	43.13	43.17	43.09	43.16	854705.0
2015-03-05 15:00:00	MSFT	Stock	43.16	43.19	43.13	43.17	1269465.0
2015-03-05 15:30:00	MSFT	Stock	43.165	43.18	43.07	43.09	3592678.0
2015-03-05 16:00:00	MSFT	Stock	43.11	43.152	43.07	43.11	3574433.0
2015-03-05 16:30:00	MSFT	Stock	43.06	43.06	43.01	43.01	568.0

> showing 50 of 82,092 rows — these rows as CSV

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