PREVIEW / stock_30min / 2015-03-24

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-24.parquet
  size:    1.6 MB
  rows:    82,348
  symbols: 3,495

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-24 04:00:00	AAPL	Stock	31.805	31.805	31.805	31.805	400.0
2015-03-24 04:30:00	AAPL	Stock	31.8725	31.935	31.8725	31.935	8000.0
2015-03-24 05:00:00	AAPL	Stock	31.8825	31.8825	31.8825	31.8825	580.0
2015-03-24 05:30:00	AAPL	Stock	31.8625	31.895	31.8625	31.895	1200.0
2015-03-24 06:00:00	AAPL	Stock	31.9125	31.925	31.9125	31.9175	9560.0
2015-03-24 06:30:00	AAPL	Stock	31.9175	31.92	31.9	31.92	6564.0
2015-03-24 07:00:00	AAPL	Stock	31.9025	31.92	31.8725	31.89	22780.0
2015-03-24 07:30:00	AAPL	Stock	31.8875	31.8975	31.87	31.8875	57160.0
2015-03-24 08:00:00	AAPL	Stock	31.8875	31.92	31.85	31.8625	289524.0
2015-03-24 08:30:00	AAPL	Stock	31.855	31.8675	31.795	31.8425	190396.0
2015-03-24 09:00:00	AAPL	Stock	31.835	31.835	31.79	31.805	251424.0
2015-03-24 09:30:00	AAPL	Stock	31.7975	31.815	31.64	31.77	19047992.0
2015-03-24 10:00:00	AAPL	Stock	31.77	32.01	31.7658	31.955	18222288.0
2015-03-24 10:30:00	AAPL	Stock	31.9545	31.96	31.875	31.9	10142292.0
2015-03-24 11:00:00	AAPL	Stock	31.9012	31.965	31.87	31.945	8081020.0
2015-03-24 11:30:00	AAPL	Stock	31.945	31.96	31.8875	31.9025	5018572.0
2015-03-24 12:00:00	AAPL	Stock	31.9	31.9362	31.87	31.89	5675864.0
2015-03-24 12:30:00	AAPL	Stock	31.8925	31.905	31.7825	31.7825	7099332.0
2015-03-24 13:00:00	AAPL	Stock	31.785	31.8688	31.7625	31.785	5450240.0
2015-03-24 13:30:00	AAPL	Stock	31.7825	31.8125	31.74	31.79	5391980.0
2015-03-24 14:00:00	AAPL	Stock	31.7875	31.7875	31.6925	31.7275	6649000.0
2015-03-24 14:30:00	AAPL	Stock	31.7275	31.7475	31.6825	31.7262	5469536.0
2015-03-24 15:00:00	AAPL	Stock	31.7275	31.775	31.6925	31.6988	6084136.0
2015-03-24 15:30:00	AAPL	Stock	31.7	31.7375	31.655	31.6725	10914548.0
2015-03-24 16:00:00	AAPL	Stock	31.6725	31.927	31.665	31.6692	7155248.0
2015-03-24 16:30:00	AAPL	Stock	31.6725	31.8238	31.6725	31.6875	211432.0
2015-03-24 17:00:00	AAPL	Stock	31.6925	31.705	31.6875	31.6975	47580.0
2015-03-24 17:30:00	AAPL	Stock	31.7	31.7075	31.6725	31.7	187124.0
2015-03-24 18:00:00	AAPL	Stock	31.7025	31.7198	31.7	31.715	50548.0
2015-03-24 18:30:00	AAPL	Stock	31.7125	31.7175	31.6975	31.715	52120.0
2015-03-24 19:00:00	AAPL	Stock	31.7125	31.7275	31.71	31.7175	36896.0
2015-03-24 19:30:00	AAPL	Stock	31.715	31.72	31.7	31.7125	38012.0
2015-03-24 07:00:00	MSFT	Stock	42.92	42.92	42.92	42.92	125.0
2015-03-24 07:30:00	MSFT	Stock	43.0	43.0	43.0	43.0	100.0
2015-03-24 08:00:00	MSFT	Stock	42.96	42.96	42.96	42.96	100.0
2015-03-24 08:30:00	MSFT	Stock	42.93	42.93	42.9	42.91	2980.0
2015-03-24 09:00:00	MSFT	Stock	42.88	43.0	42.72	42.97	123694.0
2015-03-24 09:30:00	MSFT	Stock	42.78	43.01	42.75	42.97	2650704.0
2015-03-24 10:00:00	MSFT	Stock	42.975	43.08	42.94	43.037	1153761.0
2015-03-24 10:30:00	MSFT	Stock	43.035	43.13	42.95	43.07	2342122.0
2015-03-24 11:00:00	MSFT	Stock	43.07	43.14	43.025	43.11	1596494.0
2015-03-24 11:30:00	MSFT	Stock	43.11	43.17	43.07	43.07	1028304.0
2015-03-24 12:00:00	MSFT	Stock	43.07	43.17	43.06	43.135	1142171.0
2015-03-24 12:30:00	MSFT	Stock	43.13	43.16	43.06	43.115	1190348.0
2015-03-24 13:00:00	MSFT	Stock	43.11	43.17	43.09	43.115	1215406.0
2015-03-24 13:30:00	MSFT	Stock	43.115	43.12	43.03	43.085	1045994.0
2015-03-24 14:00:00	MSFT	Stock	43.08	43.085	43.02	43.03	1297471.0
2015-03-24 14:30:00	MSFT	Stock	43.02	43.06	42.99	43.05	1123181.0
2015-03-24 15:00:00	MSFT	Stock	43.06	43.09	42.94	42.955	2018390.0
2015-03-24 15:30:00	MSFT	Stock	42.955	43.04	42.88	42.91	3379769.0

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

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