PREVIEW / stock_30min / 2007-01-03

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-01-03.parquet
  size:    1.0 MB
  rows:    55,637
  symbols: 2,509

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
2007-01-03 04:00:00	AAPL	Stock	3.0832	3.0832	3.0718	3.0718	120400.0
2007-01-03 06:00:00	AAPL	Stock	3.0804	3.0804	3.0714	3.0729	138880.0
2007-01-03 06:30:00	AAPL	Stock	3.0729	3.0729	3.0729	3.0729	5600.0
2007-01-03 07:00:00	AAPL	Stock	3.0786	3.0821	3.0686	3.0711	329000.0
2007-01-03 07:30:00	AAPL	Stock	3.0711	3.0786	3.0686	3.0771	954240.0
2007-01-03 08:00:00	AAPL	Stock	3.0786	3.0804	3.0679	3.0768	4914728.0
2007-01-03 08:30:00	AAPL	Stock	3.0768	3.0911	3.0761	3.0886	4026400.0
2007-01-03 09:00:00	AAPL	Stock	3.0889	3.0943	3.03	3.0821	3569972.0
2007-01-03 09:30:00	AAPL	Stock	3.0821	3.0921	3.06	3.0678	207034296.0
2007-01-03 10:00:00	AAPL	Stock	3.0674	3.0836	3.0529	3.0724	106275708.0
2007-01-03 10:30:00	AAPL	Stock	3.0725	3.0857	3.0682	3.0711	87163496.0
2007-01-03 11:00:00	AAPL	Stock	3.0711	3.0776	3.0418	3.0507	101391024.0
2007-01-03 11:30:00	AAPL	Stock	3.0504	3.0727	3.0493	3.0643	50104656.0
2007-01-03 12:00:00	AAPL	Stock	3.0636	3.0668	3.0496	3.0539	36525076.0
2007-01-03 12:30:00	AAPL	Stock	3.0539	3.0675	3.0511	3.06	31113096.0
2007-01-03 13:00:00	AAPL	Stock	3.06	3.0639	3.0404	3.0467	34749904.0
2007-01-03 13:30:00	AAPL	Stock	3.0464	3.0507	3.015	3.0232	76531896.0
2007-01-03 14:00:00	AAPL	Stock	3.0229	3.0261	2.9554	2.9911	148234100.0
2007-01-03 14:30:00	AAPL	Stock	2.9904	2.9911	2.925	2.9411	109804072.0
2007-01-03 15:00:00	AAPL	Stock	2.9418	2.9821	2.9379	2.9786	92642396.0
2007-01-03 15:30:00	AAPL	Stock	2.9793	2.9979	2.9768	2.9929	112640444.0
2007-01-03 16:00:00	AAPL	Stock	2.9925	2.9968	2.9893	2.9893	1760696.0
2007-01-03 16:30:00	AAPL	Stock	2.9918	2.9925	2.9893	2.9918	6910680.0
2007-01-03 17:00:00	AAPL	Stock	2.9918	2.9925	2.9893	2.9893	344736.0
2007-01-03 17:30:00	AAPL	Stock	2.9918	2.9929	2.9904	2.9911	185500.0
2007-01-03 18:00:00	AAPL	Stock	2.9918	2.9929	2.9286	2.9925	292068.0
2007-01-03 18:30:00	AAPL	Stock	2.9893	2.9921	2.9893	2.9911	107184.0
2007-01-03 19:00:00	AAPL	Stock	2.9921	2.9932	2.99	2.9925	74536.0
2007-01-03 19:30:00	AAPL	Stock	2.9925	3.0	2.9911	3.0	247800.0
2007-01-03 05:00:00	MSFT	Stock	29.87	29.87	29.87	29.87	200.0
2007-01-03 07:00:00	MSFT	Stock	29.93	29.93	29.8	29.8	200.0
2007-01-03 08:00:00	MSFT	Stock	29.87	29.99	29.86	29.96	44231.0
2007-01-03 08:30:00	MSFT	Stock	29.96	29.98	29.86	29.97	207360.0
2007-01-03 09:00:00	MSFT	Stock	29.98	30.0	29.87	29.92	163236.0
2007-01-03 09:30:00	MSFT	Stock	29.91	30.01	29.85	29.85	9719670.0
2007-01-03 10:00:00	MSFT	Stock	29.84	29.97	29.83	29.97	7350090.0
2007-01-03 10:30:00	MSFT	Stock	29.97	30.05	29.92	29.95	7490304.0
2007-01-03 11:00:00	MSFT	Stock	29.95	30.05	29.93	30.017	3986366.0
2007-01-03 11:30:00	MSFT	Stock	30.01	30.13	30.01	30.08	3670351.0
2007-01-03 12:00:00	MSFT	Stock	30.085	30.12	29.88	30.1	2512847.0
2007-01-03 12:30:00	MSFT	Stock	30.09	30.25	30.09	30.18	3529399.0
2007-01-03 13:00:00	MSFT	Stock	30.19	30.21	30.1	30.16	4231240.0
2007-01-03 13:30:00	MSFT	Stock	30.16	30.2	30.14	30.16	2355395.0
2007-01-03 14:00:00	MSFT	Stock	30.16	30.2	29.59	29.74	8695961.0
2007-01-03 14:30:00	MSFT	Stock	29.74	29.75	29.4	29.49	6125248.0
2007-01-03 15:00:00	MSFT	Stock	29.49	29.73	29.48	29.717	4526877.0
2007-01-03 15:30:00	MSFT	Stock	29.72	29.88	29.67	29.88	7047686.0
2007-01-03 16:00:00	MSFT	Stock	29.88	29.89	29.81	29.86	228778.0
2007-01-03 16:30:00	MSFT	Stock	29.84	29.86	29.82	29.86	32800.0
2007-01-03 17:00:00	MSFT	Stock	29.82	29.86	29.82	29.86	45079.0

> showing 50 of 55,637 rows — these rows as CSV

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