PREVIEW / stock_30min / 2009-01-20

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-01-20.parquet
  size:    1.2 MB
  rows:    68,699
  symbols: 3,306

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-01-20 07:00:00	AAPL	Stock	2.9004	2.9004	2.9004	2.9004	28000.0
2009-01-20 07:30:00	AAPL	Stock	2.9179	2.9179	2.9179	2.9179	25200.0
2009-01-20 08:00:00	AAPL	Stock	2.9179	2.9236	2.8857	2.8929	802844.0
2009-01-20 08:30:00	AAPL	Stock	2.8929	2.9	2.8864	2.8996	1089760.0
2009-01-20 09:00:00	AAPL	Stock	2.8996	2.9286	2.8889	2.9239	1754228.0
2009-01-20 09:30:00	AAPL	Stock	2.9239	2.9286	2.875	2.885	102832800.0
2009-01-20 10:00:00	AAPL	Stock	2.8854	2.8868	2.8543	2.8832	105271600.0
2009-01-20 10:30:00	AAPL	Stock	2.8829	2.8836	2.8318	2.8489	74838904.0
2009-01-20 11:00:00	AAPL	Stock	2.8493	2.8625	2.8393	2.845	44636368.0
2009-01-20 11:30:00	AAPL	Stock	2.845	2.8757	2.8446	2.8489	33372024.0
2009-01-20 12:00:00	AAPL	Stock	2.8486	2.8646	2.8389	2.8432	37335088.0
2009-01-20 12:30:00	AAPL	Stock	2.8436	2.8607	2.8396	2.8479	37637348.0
2009-01-20 13:00:00	AAPL	Stock	2.8475	2.8575	2.8071	2.8232	67865112.0
2009-01-20 13:30:00	AAPL	Stock	2.8229	2.83	2.8121	2.82	50496908.0
2009-01-20 14:00:00	AAPL	Stock	2.82	2.8357	2.8039	2.8171	57830444.0
2009-01-20 14:30:00	AAPL	Stock	2.8175	2.8257	2.8043	2.8086	50155252.0
2009-01-20 15:00:00	AAPL	Stock	2.8079	2.8179	2.7964	2.8161	82172468.0
2009-01-20 15:30:00	AAPL	Stock	2.8161	2.8371	2.7946	2.7964	107624832.0
2009-01-20 16:00:00	AAPL	Stock	2.7936	2.8322	2.7927	2.8107	21090244.0
2009-01-20 16:30:00	AAPL	Stock	2.8114	2.832	2.7929	2.8086	8441496.0
2009-01-20 17:00:00	AAPL	Stock	2.8086	2.8139	2.8079	2.8114	217616.0
2009-01-20 17:30:00	AAPL	Stock	2.8089	2.8268	2.7929	2.825	2725044.0
2009-01-20 18:00:00	AAPL	Stock	2.8236	2.8286	2.7929	2.8229	9604812.0
2009-01-20 18:30:00	AAPL	Stock	2.8268	2.8279	2.8214	2.8264	178752.0
2009-01-20 19:00:00	AAPL	Stock	2.8264	2.8264	2.8214	2.8214	181328.0
2009-01-20 19:30:00	AAPL	Stock	2.8214	2.83	2.8179	2.83	496748.0
2009-01-20 07:00:00	MSFT	Stock	19.5	19.52	19.5	19.52	1250.0
2009-01-20 07:30:00	MSFT	Stock	19.5	19.55	19.5	19.55	648.0
2009-01-20 08:00:00	MSFT	Stock	19.54	19.56	19.4	19.4	4741.0
2009-01-20 08:30:00	MSFT	Stock	19.42	19.45	19.42	19.45	9193.0
2009-01-20 09:00:00	MSFT	Stock	19.45	19.55	19.45	19.5	24947.0
2009-01-20 09:30:00	MSFT	Stock	19.47	19.62	19.08	19.12	6420827.0
2009-01-20 10:00:00	MSFT	Stock	19.12	19.15	19.01	19.09	4878743.0
2009-01-20 10:30:00	MSFT	Stock	19.09	19.14	18.95	18.965	4433568.0
2009-01-20 11:00:00	MSFT	Stock	18.97	19.04	18.93	18.93	3588561.0
2009-01-20 11:30:00	MSFT	Stock	18.93	19.06	18.93	18.958	6721203.0
2009-01-20 12:00:00	MSFT	Stock	18.95	19.0	18.71	18.75	6358994.0
2009-01-20 12:30:00	MSFT	Stock	18.75	18.8	18.72	18.755	5921987.0
2009-01-20 13:00:00	MSFT	Stock	18.757	18.94	18.7	18.91	7774547.0
2009-01-20 13:30:00	MSFT	Stock	18.91	18.93	18.64	18.66	5497951.0
2009-01-20 14:00:00	MSFT	Stock	18.66	18.71	18.57	18.65	4203997.0
2009-01-20 14:30:00	MSFT	Stock	18.65	18.75	18.59	18.72	4413606.0
2009-01-20 15:00:00	MSFT	Stock	18.72	18.72	18.53	18.61	6046403.0
2009-01-20 15:30:00	MSFT	Stock	18.61	18.7	18.38	18.46	13487961.0
2009-01-20 16:00:00	MSFT	Stock	18.45	18.836	18.37	18.58	7356271.0
2009-01-20 16:30:00	MSFT	Stock	18.59	18.861	18.48	18.66	1085554.0
2009-01-20 17:00:00	MSFT	Stock	18.66	18.67	18.61	18.67	27771.0
2009-01-20 17:30:00	MSFT	Stock	18.67	18.67	18.48	18.62	486155.0
2009-01-20 18:00:00	MSFT	Stock	18.62	18.68	18.48	18.65	30543.0
2009-01-20 18:30:00	MSFT	Stock	18.64	18.68	18.64	18.68	3041.0

> showing 50 of 68,699 rows — these rows as CSV

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