PREVIEW / stock_30min / 2010-12-23

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-12-23.parquet
  size:    1.4 MB
  rows:    74,957
  symbols: 3,526

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-12-23 04:00:00	AAPL	Stock	11.6054	11.6054	11.6054	11.6054	2800.0
2010-12-23 06:00:00	AAPL	Stock	11.6411	11.6411	11.6411	11.6411	2800.0
2010-12-23 07:00:00	AAPL	Stock	11.625	11.625	11.6211	11.6211	25200.0
2010-12-23 07:30:00	AAPL	Stock	11.6161	11.6161	11.6018	11.6111	120484.0
2010-12-23 08:00:00	AAPL	Stock	11.6071	11.61	11.6007	11.6071	293356.0
2010-12-23 08:30:00	AAPL	Stock	11.6107	11.6129	11.6011	11.6114	504560.0
2010-12-23 09:00:00	AAPL	Stock	11.6104	11.6107	11.6043	11.6071	477540.0
2010-12-23 09:30:00	AAPL	Stock	11.6071	11.6125	11.5893	11.5907	27216868.0
2010-12-23 10:00:00	AAPL	Stock	11.5907	11.6004	11.5554	11.5607	25758488.0
2010-12-23 10:30:00	AAPL	Stock	11.5589	11.5679	11.5529	11.56	17869264.0
2010-12-23 11:00:00	AAPL	Stock	11.5618	11.5857	11.5607	11.5857	17007284.0
2010-12-23 11:30:00	AAPL	Stock	11.5854	11.5875	11.5625	11.5677	12985112.0
2010-12-23 12:00:00	AAPL	Stock	11.5661	11.5671	11.5482	11.5647	11079768.0
2010-12-23 12:30:00	AAPL	Stock	11.5654	11.57	11.5536	11.5582	5721520.0
2010-12-23 13:00:00	AAPL	Stock	11.5584	11.5668	11.5582	11.563	6408612.0
2010-12-23 13:30:00	AAPL	Stock	11.5629	11.5636	11.5564	11.56	5253892.0
2010-12-23 14:00:00	AAPL	Stock	11.5609	11.5614	11.5479	11.5486	12191228.0
2010-12-23 14:30:00	AAPL	Stock	11.5493	11.5596	11.5418	11.5532	12110476.0
2010-12-23 15:00:00	AAPL	Stock	11.5539	11.5664	11.5505	11.5664	8532076.0
2010-12-23 15:30:00	AAPL	Stock	11.5664	11.5668	11.5521	11.5571	19689908.0
2010-12-23 16:00:00	AAPL	Stock	11.5561	11.5695	11.5482	11.5536	35261408.0
2010-12-23 16:30:00	AAPL	Stock	11.5532	11.5964	11.5532	11.5571	712768.0
2010-12-23 17:00:00	AAPL	Stock	11.5543	11.5568	11.5529	11.5568	61628.0
2010-12-23 17:30:00	AAPL	Stock	11.5571	11.5575	11.5536	11.5536	228704.0
2010-12-23 18:00:00	AAPL	Stock	11.5536	11.5571	11.5518	11.5518	78568.0
2010-12-23 18:30:00	AAPL	Stock	11.5518	11.5589	11.5518	11.5571	52108.0
2010-12-23 19:00:00	AAPL	Stock	11.5589	11.5593	11.5554	11.5561	21560.0
2010-12-23 19:30:00	AAPL	Stock	11.5568	11.5571	11.5486	11.5504	193956.0
2010-12-23 04:30:00	MSFT	Stock	28.12	28.12	28.1	28.1	1000.0
2010-12-23 06:30:00	MSFT	Stock	28.09	28.09	28.09	28.09	900.0
2010-12-23 07:00:00	MSFT	Stock	28.08	28.08	28.08	28.08	1100.0
2010-12-23 08:00:00	MSFT	Stock	28.1	28.16	28.1	28.11	3700.0
2010-12-23 08:30:00	MSFT	Stock	28.1	28.14	28.1	28.11	2500.0
2010-12-23 09:00:00	MSFT	Stock	28.11	28.19	27.98	27.98	96099.0
2010-12-23 09:30:00	MSFT	Stock	27.98	28.29	27.96	28.212	2887640.0
2010-12-23 10:00:00	MSFT	Stock	28.22	28.28	28.17	28.21	1897980.0
2010-12-23 10:30:00	MSFT	Stock	28.21	28.25	28.18	28.23	1812303.0
2010-12-23 11:00:00	MSFT	Stock	28.23	28.24	28.17	28.22	1667141.0
2010-12-23 11:30:00	MSFT	Stock	28.22	28.245	28.15	28.16	1707764.0
2010-12-23 12:00:00	MSFT	Stock	28.17	28.19	28.14	28.16	1041228.0
2010-12-23 12:30:00	MSFT	Stock	28.17	28.21	28.16	28.2	910185.0
2010-12-23 13:00:00	MSFT	Stock	28.2	28.27	28.2	28.235	1320922.0
2010-12-23 13:30:00	MSFT	Stock	28.235	28.26	28.21	28.21	849289.0
2010-12-23 14:00:00	MSFT	Stock	28.211	28.24	28.17	28.21	1434439.0
2010-12-23 14:30:00	MSFT	Stock	28.22	28.29	28.21	28.29	2122797.0
2010-12-23 15:00:00	MSFT	Stock	28.29	28.32	28.25	28.28	1976241.0
2010-12-23 15:30:00	MSFT	Stock	28.288	28.32	28.25	28.31	3344843.0
2010-12-23 16:00:00	MSFT	Stock	28.3	28.312	28.143	28.3	1146979.0
2010-12-23 16:30:00	MSFT	Stock	28.306	28.306	28.288	28.288	75412.0
2010-12-23 17:00:00	MSFT	Stock	28.31	28.31	28.31	28.31	400.0

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

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