PREVIEW / stock_30min / 2010-11-19

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-11-19.parquet
  size:    1.4 MB
  rows:    74,868
  symbols: 3,525

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
2010-11-19 04:00:00	AAPL	Stock	11.0357	11.0429	11.0357	11.0357	11200.0
2010-11-19 04:30:00	AAPL	Stock	11.0093	11.0093	11.0093	11.0093	2800.0
2010-11-19 05:30:00	AAPL	Stock	11.0093	11.0332	10.9971	11.0332	19600.0
2010-11-19 06:00:00	AAPL	Stock	11.0429	11.0479	11.0429	11.0479	5600.0
2010-11-19 07:00:00	AAPL	Stock	11.0179	11.0379	10.9786	10.9786	96600.0
2010-11-19 07:30:00	AAPL	Stock	10.9579	10.9893	10.9579	10.9864	39900.0
2010-11-19 08:00:00	AAPL	Stock	10.9857	11.0179	10.9754	11.0071	890260.0
2010-11-19 08:30:00	AAPL	Stock	11.0054	11.0293	11.0029	11.0179	614208.0
2010-11-19 09:00:00	AAPL	Stock	11.0182	11.0182	10.9839	11.0	1187620.0
2010-11-19 09:30:00	AAPL	Stock	10.9989	11.0143	10.9464	10.9564	90527948.0
2010-11-19 10:00:00	AAPL	Stock	10.9579	10.9664	10.9214	10.9446	41196876.0
2010-11-19 10:30:00	AAPL	Stock	10.945	10.9846	10.9314	10.9586	38003056.0
2010-11-19 11:00:00	AAPL	Stock	10.9596	10.9646	10.9014	10.9307	32619440.0
2010-11-19 11:30:00	AAPL	Stock	10.9304	10.9571	10.9236	10.9364	21954016.0
2010-11-19 12:00:00	AAPL	Stock	10.9375	10.9446	10.9314	10.9335	10221120.0
2010-11-19 12:30:00	AAPL	Stock	10.9336	10.9604	10.9168	10.9525	17886764.0
2010-11-19 13:00:00	AAPL	Stock	10.9525	10.9693	10.9482	10.9629	12109328.0
2010-11-19 13:30:00	AAPL	Stock	10.9632	10.9768	10.9614	10.9718	11426380.0
2010-11-19 14:00:00	AAPL	Stock	10.9721	10.9993	10.9686	10.9773	19086284.0
2010-11-19 14:30:00	AAPL	Stock	10.9768	10.9821	10.9607	10.9686	14018928.0
2010-11-19 15:00:00	AAPL	Stock	10.9689	10.98	10.9461	10.9471	17283560.0
2010-11-19 15:30:00	AAPL	Stock	10.9488	10.9607	10.9209	10.9607	38073476.0
2010-11-19 16:00:00	AAPL	Stock	10.9607	10.9869	10.9496	10.9536	11996936.0
2010-11-19 16:30:00	AAPL	Stock	10.9571	10.9589	10.95	10.9575	201432.0
2010-11-19 17:00:00	AAPL	Stock	10.9589	10.9618	10.9575	10.9607	210028.0
2010-11-19 17:30:00	AAPL	Stock	10.9593	10.9629	10.9582	10.96	29260.0
2010-11-19 18:00:00	AAPL	Stock	10.9593	10.9621	10.9546	10.9557	160272.0
2010-11-19 18:30:00	AAPL	Stock	10.9611	10.9611	10.9571	10.9571	37800.0
2010-11-19 19:00:00	AAPL	Stock	10.9571	10.9625	10.9571	10.9625	51100.0
2010-11-19 19:30:00	AAPL	Stock	10.9639	10.9643	10.9625	10.9643	106260.0
2010-11-19 05:00:00	MSFT	Stock	25.95	25.95	25.95	25.95	200.0
2010-11-19 08:00:00	MSFT	Stock	25.84	25.93	25.84	25.87	2350.0
2010-11-19 08:30:00	MSFT	Stock	25.83	25.87	25.82	25.87	2550.0
2010-11-19 09:00:00	MSFT	Stock	25.85	25.9	25.79	25.79	65791.0
2010-11-19 09:30:00	MSFT	Stock	25.8	25.83	25.6	25.67	7849929.0
2010-11-19 10:00:00	MSFT	Stock	25.66	25.72	25.65	25.678	3322893.0
2010-11-19 10:30:00	MSFT	Stock	25.67	25.76	25.655	25.69	3368728.0
2010-11-19 11:00:00	MSFT	Stock	25.7	25.71	25.67	25.695	3480389.0
2010-11-19 11:30:00	MSFT	Stock	25.7	25.7	25.68	25.69	1877076.0
2010-11-19 12:00:00	MSFT	Stock	25.7	25.71	25.69	25.69	2135158.0
2010-11-19 12:30:00	MSFT	Stock	25.695	25.75	25.67	25.743	1922928.0
2010-11-19 13:00:00	MSFT	Stock	25.748	25.76	25.72	25.72	1164667.0
2010-11-19 13:30:00	MSFT	Stock	25.72	25.73	25.7	25.705	1819240.0
2010-11-19 14:00:00	MSFT	Stock	25.71	25.73	25.7	25.73	2963871.0
2010-11-19 14:30:00	MSFT	Stock	25.73	25.74	25.7	25.7	2022183.0
2010-11-19 15:00:00	MSFT	Stock	25.705	25.71	25.68	25.699	2211288.0
2010-11-19 15:30:00	MSFT	Stock	25.7	25.73	25.66	25.7	6962008.0
2010-11-19 16:00:00	MSFT	Stock	25.705	25.83	25.65	25.7	3643561.0
2010-11-19 16:30:00	MSFT	Stock	25.68	25.72	25.68	25.72	12100.0
2010-11-19 17:00:00	MSFT	Stock	25.71	25.73	25.71	25.73	1754.0

> showing 50 of 74,868 rows — these rows as CSV

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