PREVIEW / stock_30min / 2007-02-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-02-20.parquet
  size:    1003 KB
  rows:    54,459
  symbols: 2,535

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-02-20 06:30:00	AAPL	Stock	3.0304	3.0304	3.0304	3.0304	11200.0
2007-02-20 08:00:00	AAPL	Stock	3.0296	3.0296	3.0193	3.0296	81844.0
2007-02-20 08:30:00	AAPL	Stock	3.0321	3.0357	3.0296	3.0321	358484.0
2007-02-20 09:00:00	AAPL	Stock	3.0321	3.035	3.0196	3.0232	862120.0
2007-02-20 09:30:00	AAPL	Stock	3.0232	3.0489	3.0057	3.0482	101636444.0
2007-02-20 10:00:00	AAPL	Stock	3.0482	3.0489	3.0214	3.0307	62429052.0
2007-02-20 10:30:00	AAPL	Stock	3.0304	3.0461	3.0279	3.0418	41008772.0
2007-02-20 11:00:00	AAPL	Stock	3.0418	3.0518	3.0375	3.0507	43448020.0
2007-02-20 11:30:00	AAPL	Stock	3.0507	3.0582	3.0507	3.0529	46608688.0
2007-02-20 12:00:00	AAPL	Stock	3.0525	3.0679	3.0521	3.0632	40201728.0
2007-02-20 12:30:00	AAPL	Stock	3.0636	3.0657	3.0586	3.0614	27528844.0
2007-02-20 13:00:00	AAPL	Stock	3.0614	3.0757	3.0604	3.0696	48451900.0
2007-02-20 13:30:00	AAPL	Stock	3.07	3.0771	3.0696	3.0736	27981828.0
2007-02-20 14:00:00	AAPL	Stock	3.0736	3.075	3.0636	3.0661	24824016.0
2007-02-20 14:30:00	AAPL	Stock	3.0661	3.0739	3.0654	3.0718	39258968.0
2007-02-20 15:00:00	AAPL	Stock	3.0721	3.075	3.0646	3.0689	29881096.0
2007-02-20 15:30:00	AAPL	Stock	3.0689	3.0707	3.0657	3.0679	44289196.0
2007-02-20 16:00:00	AAPL	Stock	3.0679	3.0682	3.0646	3.0679	2785160.0
2007-02-20 16:30:00	AAPL	Stock	3.0657	3.0679	3.0657	3.0679	111440.0
2007-02-20 17:00:00	AAPL	Stock	3.0664	3.0704	3.0664	3.0679	198324.0
2007-02-20 17:30:00	AAPL	Stock	3.0696	3.0704	3.0675	3.0675	148484.0
2007-02-20 18:00:00	AAPL	Stock	3.0689	3.0689	3.0675	3.0686	39200.0
2007-02-20 18:30:00	AAPL	Stock	3.0686	3.0704	3.0686	3.0704	103600.0
2007-02-20 19:00:00	AAPL	Stock	3.0693	3.0704	3.0686	3.0686	100380.0
2007-02-20 19:30:00	AAPL	Stock	3.0679	3.0704	3.0679	3.0704	52556.0
2007-02-20 04:00:00	MSFT	Stock	28.52	28.52	28.52	28.52	100.0
2007-02-20 07:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	4000.0
2007-02-20 07:30:00	MSFT	Stock	28.55	28.63	28.55	28.58	9700.0
2007-02-20 08:00:00	MSFT	Stock	28.64	28.64	28.56	28.59	36040.0
2007-02-20 08:30:00	MSFT	Stock	28.58	28.65	28.58	28.62	34610.0
2007-02-20 09:00:00	MSFT	Stock	28.64	28.68	28.6	28.64	109050.0
2007-02-20 09:30:00	MSFT	Stock	28.63	28.68	28.54	28.54	8252116.0
2007-02-20 10:00:00	MSFT	Stock	28.54	28.59	28.47	28.585	6005288.0
2007-02-20 10:30:00	MSFT	Stock	28.585	28.61	28.54	28.557	3271759.0
2007-02-20 11:00:00	MSFT	Stock	28.56	28.63	28.54	28.63	3286471.0
2007-02-20 11:30:00	MSFT	Stock	28.63	28.7	28.59	28.65	3742289.0
2007-02-20 12:00:00	MSFT	Stock	28.65	28.75	28.63	28.67	2587237.0
2007-02-20 12:30:00	MSFT	Stock	28.679	28.71	28.64	28.71	1882398.0
2007-02-20 13:00:00	MSFT	Stock	28.71	28.75	28.67	28.7	1713998.0
2007-02-20 13:30:00	MSFT	Stock	28.71	28.86	28.69	28.82	3489616.0
2007-02-20 14:00:00	MSFT	Stock	28.82	28.86	28.7	28.79	4858630.0
2007-02-20 14:30:00	MSFT	Stock	28.78	28.82	28.73	28.76	2747007.0
2007-02-20 15:00:00	MSFT	Stock	28.76	28.8	28.73	28.75	2499933.0
2007-02-20 15:30:00	MSFT	Stock	28.76	28.85	28.75	28.83	6447033.0
2007-02-20 16:00:00	MSFT	Stock	28.82	28.85	28.76	28.81	164556.0
2007-02-20 16:30:00	MSFT	Stock	28.83	28.83	28.79	28.79	203600.0
2007-02-20 17:00:00	MSFT	Stock	28.79	28.83	28.79	28.83	390436.0
2007-02-20 18:00:00	MSFT	Stock	28.82	28.83	28.75	28.75	11567.0
2007-02-20 19:00:00	MSFT	Stock	28.78	28.8	28.78	28.8	550.0
2007-02-20 19:30:00	MSFT	Stock	28.75	28.79	28.75	28.75	2350.0

> showing 50 of 54,459 rows — these rows as CSV

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