PREVIEW / stock_30min / 2014-12-22

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-22.parquet
  size:    1.6 MB
  rows:    85,650
  symbols: 3,566

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
2014-12-22 04:00:00	AAPL	Stock	28.0925	28.105	28.0925	28.105	1600.0
2014-12-22 04:30:00	AAPL	Stock	28.05	28.05	28.05	28.05	400.0
2014-12-22 05:00:00	AAPL	Stock	28.06	28.07	28.06	28.07	868.0
2014-12-22 05:30:00	AAPL	Stock	28.07	28.07	28.0525	28.0525	3800.0
2014-12-22 06:00:00	AAPL	Stock	28.06	28.0625	28.06	28.0625	3992.0
2014-12-22 06:30:00	AAPL	Stock	28.0575	28.065	28.055	28.065	13848.0
2014-12-22 07:00:00	AAPL	Stock	28.055	28.055	28.0125	28.04	64832.0
2014-12-22 07:30:00	AAPL	Stock	28.0375	28.05	28.01	28.0275	70092.0
2014-12-22 08:00:00	AAPL	Stock	28.025	28.0625	27.945	28.025	262936.0
2014-12-22 08:30:00	AAPL	Stock	28.025	28.035	28.0	28.035	182628.0
2014-12-22 09:00:00	AAPL	Stock	28.035	28.07	28.0025	28.06	369400.0
2014-12-22 09:30:00	AAPL	Stock	28.06	28.1795	27.9925	28.098	19891540.0
2014-12-22 10:00:00	AAPL	Stock	28.0952	28.31	28.0575	28.3088	13570804.0
2014-12-22 10:30:00	AAPL	Stock	28.3088	28.3725	28.2575	28.2825	12830324.0
2014-12-22 11:00:00	AAPL	Stock	28.28	28.3125	28.2125	28.3	9351100.0
2014-12-22 11:30:00	AAPL	Stock	28.3012	28.3525	28.225	28.2462	7511472.0
2014-12-22 12:00:00	AAPL	Stock	28.245	28.255	28.22	28.2275	5632240.0
2014-12-22 12:30:00	AAPL	Stock	28.2275	28.2275	28.1625	28.1725	5797764.0
2014-12-22 13:00:00	AAPL	Stock	28.17	28.205	28.1375	28.175	5651488.0
2014-12-22 13:30:00	AAPL	Stock	28.175	28.1825	28.155	28.18	5664820.0
2014-12-22 14:00:00	AAPL	Stock	28.18	28.18	28.1	28.1212	6236884.0
2014-12-22 14:30:00	AAPL	Stock	28.1212	28.1575	28.11	28.125	5691432.0
2014-12-22 15:00:00	AAPL	Stock	28.125	28.25	28.125	28.2475	10093624.0
2014-12-22 15:30:00	AAPL	Stock	28.2475	28.2725	28.205	28.235	16748800.0
2014-12-22 16:00:00	AAPL	Stock	28.235	28.25	28.1688	28.235	32797488.0
2014-12-22 16:30:00	AAPL	Stock	28.2275	28.2425	28.2	28.2	221772.0
2014-12-22 17:00:00	AAPL	Stock	28.1875	28.235	28.1875	28.19	258848.0
2014-12-22 17:30:00	AAPL	Stock	28.21	28.235	28.2	28.235	137348.0
2014-12-22 18:00:00	AAPL	Stock	28.2125	28.235	28.175	28.235	31224.0
2014-12-22 18:30:00	AAPL	Stock	28.235	28.235	28.1525	28.21	47312.0
2014-12-22 19:00:00	AAPL	Stock	28.21	28.21	28.16	28.205	31948.0
2014-12-22 19:30:00	AAPL	Stock	28.215	28.215	28.1675	28.1775	26000.0
2014-12-22 05:30:00	MSFT	Stock	47.86	47.86	47.86	47.86	200.0
2014-12-22 06:30:00	MSFT	Stock	47.89	47.9	47.89	47.9	200.0
2014-12-22 07:00:00	MSFT	Stock	47.85	47.85	47.85	47.85	2400.0
2014-12-22 07:30:00	MSFT	Stock	47.8	47.8	47.8	47.8	200.0
2014-12-22 08:00:00	MSFT	Stock	47.77	47.85	47.77	47.85	658.0
2014-12-22 08:30:00	MSFT	Stock	47.8	47.9	47.78	47.8	2358.0
2014-12-22 09:00:00	MSFT	Stock	47.89	47.89	47.74	47.78	30248.0
2014-12-22 09:30:00	MSFT	Stock	47.82	48.12	47.71	47.97	2435410.0
2014-12-22 10:00:00	MSFT	Stock	47.975	48.07	47.84	48.01	1267920.0
2014-12-22 10:30:00	MSFT	Stock	48.02	48.1	47.96	47.97	1004165.0
2014-12-22 11:00:00	MSFT	Stock	47.97	47.98	47.84	47.98	1430038.0
2014-12-22 11:30:00	MSFT	Stock	47.98	48.02	47.835	47.835	734875.0
2014-12-22 12:00:00	MSFT	Stock	47.835	47.92	47.8	47.87	803508.0
2014-12-22 12:30:00	MSFT	Stock	47.86	47.89	47.78	47.835	827266.0
2014-12-22 13:00:00	MSFT	Stock	47.84	47.9	47.78	47.87	729351.0
2014-12-22 13:30:00	MSFT	Stock	47.865	47.89	47.82	47.865	595227.0
2014-12-22 14:00:00	MSFT	Stock	47.86	47.95	47.84	47.9	1135026.0
2014-12-22 14:30:00	MSFT	Stock	47.9	47.915	47.83	47.87	1105387.0

> showing 50 of 85,650 rows — these rows as CSV

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