PREVIEW / stock_30min / 2009-12-07

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-12-07.parquet
  size:    1.3 MB
  rows:    71,922
  symbols: 3,428

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
2009-12-07 04:00:00	AAPL	Stock	6.8611	6.8611	6.8596	6.8596	12936.0
2009-12-07 07:00:00	AAPL	Stock	6.8782	6.9039	6.8782	6.9039	32116.0
2009-12-07 07:30:00	AAPL	Stock	6.9179	6.9386	6.9179	6.9318	92988.0
2009-12-07 08:00:00	AAPL	Stock	6.9454	6.9464	6.9071	6.9075	584640.0
2009-12-07 08:30:00	AAPL	Stock	6.9082	6.9139	6.9007	6.9021	477232.0
2009-12-07 09:00:00	AAPL	Stock	6.9046	6.91	6.8957	6.9043	544236.0
2009-12-07 09:30:00	AAPL	Stock	6.9043	6.9204	6.7414	6.8004	161116116.0
2009-12-07 10:00:00	AAPL	Stock	6.7993	6.8268	6.7714	6.8164	84577864.0
2009-12-07 10:30:00	AAPL	Stock	6.8164	6.8618	6.8157	6.8393	53650996.0
2009-12-07 11:00:00	AAPL	Stock	6.8386	6.8457	6.7946	6.7987	31232152.0
2009-12-07 11:30:00	AAPL	Stock	6.7989	6.8246	6.7971	6.8154	22692600.0
2009-12-07 12:00:00	AAPL	Stock	6.8154	6.8168	6.8064	6.8121	16534056.0
2009-12-07 12:30:00	AAPL	Stock	6.8132	6.8332	6.8036	6.8043	24465224.0
2009-12-07 13:00:00	AAPL	Stock	6.8043	6.8571	6.8036	6.84	42905940.0
2009-12-07 13:30:00	AAPL	Stock	6.84	6.847	6.8096	6.8136	24640924.0
2009-12-07 14:00:00	AAPL	Stock	6.8136	6.8175	6.7911	6.7951	27126764.0
2009-12-07 14:30:00	AAPL	Stock	6.7954	6.7957	6.7579	6.7707	57099504.0
2009-12-07 15:00:00	AAPL	Stock	6.7718	6.7779	6.7414	6.7439	58229052.0
2009-12-07 15:30:00	AAPL	Stock	6.7439	6.7721	6.7386	6.75	85543892.0
2009-12-07 16:00:00	AAPL	Stock	6.7507	6.8015	6.7431	6.7679	10609984.0
2009-12-07 16:30:00	AAPL	Stock	6.7675	6.8112	6.7427	6.7607	1257312.0
2009-12-07 17:00:00	AAPL	Stock	6.9043	6.9043	6.76	6.7625	501676.0
2009-12-07 17:30:00	AAPL	Stock	6.7614	6.7714	6.7607	6.7714	871276.0
2009-12-07 18:00:00	AAPL	Stock	6.7679	6.7739	6.7482	6.7732	803796.0
2009-12-07 18:30:00	AAPL	Stock	6.7725	6.7796	6.7696	6.7796	120064.0
2009-12-07 19:00:00	AAPL	Stock	6.7796	6.78	6.7775	6.7786	97580.0
2009-12-07 19:30:00	AAPL	Stock	6.7786	6.7818	6.7743	6.7786	182868.0
2009-12-07 04:30:00	MSFT	Stock	29.8	29.8	29.78	29.78	490.0
2009-12-07 07:30:00	MSFT	Stock	29.8	29.8	29.79	29.79	2200.0
2009-12-07 08:00:00	MSFT	Stock	29.89	29.95	29.89	29.94	2833.0
2009-12-07 08:30:00	MSFT	Stock	29.86	29.96	29.86	29.88	3800.0
2009-12-07 09:00:00	MSFT	Stock	29.91	29.92	29.72	29.78	42900.0
2009-12-07 09:30:00	MSFT	Stock	29.77	30.08	29.7	29.95	5124061.0
2009-12-07 10:00:00	MSFT	Stock	29.95	29.98	29.84	29.86	3842306.0
2009-12-07 10:30:00	MSFT	Stock	29.87	29.9	29.83	29.87	2500264.0
2009-12-07 11:00:00	MSFT	Stock	29.87	29.915	29.84	29.89	1678394.0
2009-12-07 11:30:00	MSFT	Stock	29.89	29.91	29.85	29.862	2274680.0
2009-12-07 12:00:00	MSFT	Stock	29.87	29.87	29.85	29.853	1336422.0
2009-12-07 12:30:00	MSFT	Stock	29.85	29.93	29.85	29.881	2155895.0
2009-12-07 13:00:00	MSFT	Stock	29.88	29.89	29.82	29.84	1374384.0
2009-12-07 13:30:00	MSFT	Stock	29.84	29.88	29.78	29.86	2584304.0
2009-12-07 14:00:00	MSFT	Stock	29.85	29.88	29.82	29.82	1478391.0
2009-12-07 14:30:00	MSFT	Stock	29.82	29.827	29.68	29.7	3690015.0
2009-12-07 15:00:00	MSFT	Stock	29.71	29.81	29.68	29.78	2783184.0
2009-12-07 15:30:00	MSFT	Stock	29.79	29.82	29.75	29.78	4048717.0
2009-12-07 16:00:00	MSFT	Stock	29.8	29.851	29.72	29.72	1570279.0
2009-12-07 16:30:00	MSFT	Stock	29.794	29.89	29.75	29.89	11600.0
2009-12-07 17:00:00	MSFT	Stock	29.98	29.98	29.72	29.75	2500.0
2009-12-07 17:30:00	MSFT	Stock	29.75	29.75	29.74	29.74	1400.0
2009-12-07 18:00:00	MSFT	Stock	29.75	29.75	29.75	29.75	500.0

> showing 50 of 71,922 rows — these rows as CSV

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