PREVIEW / etf_30min / 2009-01-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-21.parquet
  size:    206 KB
  rows:    6,786

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-21 04:00:00	SPY	ETF	81.25	81.33	81.04	81.11	2300.0
2009-01-21 04:30:00	SPY	ETF	81.28	81.28	81.0	81.0	1000.0
2009-01-21 05:00:00	SPY	ETF	80.98	81.59	80.98	81.59	1000.0
2009-01-21 05:30:00	SPY	ETF	81.48	81.87	81.48	81.87	7000.0
2009-01-21 06:00:00	SPY	ETF	81.79	82.25	81.28	81.95	27000.0
2009-01-21 06:30:00	SPY	ETF	82.0	82.0	81.7	81.81	84400.0
2009-01-21 07:00:00	SPY	ETF	81.65	81.79	81.41	81.61	325420.0
2009-01-21 07:30:00	SPY	ETF	81.57	81.67	81.26	81.35	711412.0
2009-01-21 08:00:00	SPY	ETF	81.34	81.93	81.27	81.65	1678867.0
2009-01-21 08:30:00	SPY	ETF	81.65	82.0	81.04	81.8	1563261.0
2009-01-21 09:00:00	SPY	ETF	81.79	82.05	81.7	81.93	2359094.0
2009-01-21 09:30:00	SPY	ETF	81.94	82.4	81.52	82.25	34389342.0
2009-01-21 10:00:00	SPY	ETF	82.27	82.46	81.64	81.6792	32835935.0
2009-01-21 10:30:00	SPY	ETF	81.67	81.79	80.47	80.56	31008067.0
2009-01-21 11:00:00	SPY	ETF	80.55	81.19	80.54	81.19	25674951.0
2009-01-21 11:30:00	SPY	ETF	81.19	81.71	81.12	81.31	20632813.0
2009-01-21 12:00:00	SPY	ETF	81.31	81.82	81.15	81.37	16167063.0
2009-01-21 12:30:00	SPY	ETF	81.38	81.65	81.16	81.62	14859299.0
2009-01-21 13:00:00	SPY	ETF	81.63	81.88	81.18	81.28	13595934.0
2009-01-21 13:30:00	SPY	ETF	81.28	82.13	81.22	82.12	22007592.0
2009-01-21 14:00:00	SPY	ETF	82.12	82.38	81.8	82.24	22079899.0
2009-01-21 14:30:00	SPY	ETF	82.2391	83.02	82.2391	82.95	24324657.0
2009-01-21 15:00:00	SPY	ETF	82.93	83.43	81.65	83.05	32400448.0
2009-01-21 15:30:00	SPY	ETF	83.05	84.24	82.9	84.04	46953785.0
2009-01-21 16:00:00	SPY	ETF	84.05	84.21	80.5925	84.15	14351439.0
2009-01-21 16:30:00	SPY	ETF	84.1	84.67	80.5925	84.29	4847512.0
2009-01-21 17:00:00	SPY	ETF	84.29	84.52	84.27	84.46	394059.0
2009-01-21 17:30:00	SPY	ETF	84.5	84.55	84.39	84.45	165950.0
2009-01-21 18:00:00	SPY	ETF	84.43	84.54	84.37	84.41	237429.0
2009-01-21 18:30:00	SPY	ETF	84.4	84.47	84.37	84.37	123735.0
2009-01-21 19:00:00	SPY	ETF	84.39	84.39	84.18	84.2	35251.0
2009-01-21 19:30:00	SPY	ETF	84.2	84.2	84.03	84.1	120066.0
2009-01-21 04:30:00	QQQ	ETF	28.21	28.21	28.21	28.21	443.0
2009-01-21 05:00:00	QQQ	ETF	28.2	28.2	28.2	28.2	185.0
2009-01-21 05:30:00	QQQ	ETF	28.28	28.39	28.28	28.39	1375.0
2009-01-21 06:00:00	QQQ	ETF	28.37	28.49	28.34	28.49	1500.0
2009-01-21 06:30:00	QQQ	ETF	28.44	28.44	28.44	28.44	100.0
2009-01-21 07:00:00	QQQ	ETF	28.4	28.43	28.34	28.34	78667.0
2009-01-21 07:30:00	QQQ	ETF	28.3	28.33	28.24	28.24	190486.0
2009-01-21 08:00:00	QQQ	ETF	28.25	28.32	28.21	28.32	455119.0
2009-01-21 08:30:00	QQQ	ETF	28.31	28.65	28.3	28.41	537170.0
2009-01-21 09:00:00	QQQ	ETF	28.42	28.44	28.34	28.43	508637.0
2009-01-21 09:30:00	QQQ	ETF	28.43	28.65	28.35	28.61	18082517.0
2009-01-21 10:00:00	QQQ	ETF	28.61	28.68	28.42	28.43	13301588.0
2009-01-21 10:30:00	QQQ	ETF	28.43	28.48	28.1	28.13	11548270.0
2009-01-21 11:00:00	QQQ	ETF	28.125	28.31	28.11	28.291	8496237.0
2009-01-21 11:30:00	QQQ	ETF	28.29	28.4	28.27	28.31	5557409.0
2009-01-21 12:00:00	QQQ	ETF	28.31	28.48	28.26	28.3	6438016.0
2009-01-21 12:30:00	QQQ	ETF	28.29	28.39	28.24	28.35	5219030.0
2009-01-21 13:00:00	QQQ	ETF	28.35	28.44	28.23	28.258	4705635.0

> showing 50 of 6,786 rows — these rows as CSV

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