PREVIEW / etf_30min / 2008-04-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-18.parquet
  size:    167 KB
  rows:    5,896

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
2008-04-18 05:30:00	SPY	ETF	137.28	137.28	137.28	137.28	100.0
2008-04-18 06:00:00	SPY	ETF	137.45	137.54	137.45	137.54	1100.0
2008-04-18 06:30:00	SPY	ETF	137.6	138.17	137.6	138.17	403554.0
2008-04-18 07:00:00	SPY	ETF	138.12	138.6	138.12	138.39	1243742.0
2008-04-18 07:30:00	SPY	ETF	138.38	138.77	138.32	138.62	1783422.0
2008-04-18 08:00:00	SPY	ETF	138.56	138.75	138.0239	138.64	2589712.0
2008-04-18 08:30:00	SPY	ETF	138.63	138.95	138.55	138.94	3123032.0
2008-04-18 09:00:00	SPY	ETF	138.94	138.97	138.8	138.95	2965872.0
2008-04-18 09:30:00	SPY	ETF	138.94	138.98	138.41	138.51	21623305.0
2008-04-18 10:00:00	SPY	ETF	138.51	138.6	138.26	138.42	16478659.0
2008-04-18 10:30:00	SPY	ETF	138.41	139.01	138.37	138.85	19823134.0
2008-04-18 11:00:00	SPY	ETF	138.85	139.08	138.65	138.9201	17805592.0
2008-04-18 11:30:00	SPY	ETF	138.92	139.33	138.78	139.23	12349413.0
2008-04-18 12:00:00	SPY	ETF	139.22	139.44	139.09	139.37	10982113.0
2008-04-18 12:30:00	SPY	ETF	139.38	139.44	139.18	139.21	8398631.0
2008-04-18 13:00:00	SPY	ETF	139.2	139.56	139.18	139.49	8201012.0
2008-04-18 13:30:00	SPY	ETF	139.49	139.53	139.18	139.29	10303803.0
2008-04-18 14:00:00	SPY	ETF	139.3	139.4	138.86	138.95	13430857.0
2008-04-18 14:30:00	SPY	ETF	138.96	139.19	138.94	139.0	8675783.0
2008-04-18 15:00:00	SPY	ETF	139.0	139.03	138.51	138.58	15067867.0
2008-04-18 15:30:00	SPY	ETF	138.58	139.07	138.56	138.93	20076979.0
2008-04-18 16:00:00	SPY	ETF	138.9399	138.96	138.48	138.6	11858936.0
2008-04-18 16:30:00	SPY	ETF	138.6	138.7	138.5	138.55	2824458.0
2008-04-18 17:00:00	SPY	ETF	138.55	138.63	138.47	138.5	133431.0
2008-04-18 17:30:00	SPY	ETF	138.5	138.8228	138.48	138.6	1220689.0
2008-04-18 18:00:00	SPY	ETF	138.6	138.6	138.54	138.54	17436.0
2008-04-18 18:30:00	SPY	ETF	138.61	138.62	138.54	138.54	2155.0
2008-04-18 19:00:00	SPY	ETF	138.54	138.54	138.45	138.45	11556.0
2008-04-18 19:30:00	SPY	ETF	138.47	138.58	138.47	138.58	1424.0
2008-04-18 04:00:00	QQQ	ETF	45.97	45.97	45.97	45.97	200.0
2008-04-18 04:30:00	QQQ	ETF	45.9	45.9	45.9	45.9	100.0
2008-04-18 05:00:00	QQQ	ETF	45.92	45.96	45.92	45.96	900.0
2008-04-18 05:30:00	QQQ	ETF	45.97	46.0	45.94	46.0	500.0
2008-04-18 06:00:00	QQQ	ETF	46.0	46.09	46.0	46.09	3000.0
2008-04-18 06:30:00	QQQ	ETF	46.09	46.17	46.08	46.13	130700.0
2008-04-18 07:00:00	QQQ	ETF	46.13	46.24	46.13	46.18	229889.0
2008-04-18 07:30:00	QQQ	ETF	46.17	46.24	46.14	46.23	827652.0
2008-04-18 08:00:00	QQQ	ETF	46.23	46.36	46.0	46.34	1847301.0
2008-04-18 08:30:00	QQQ	ETF	46.35	46.43	46.31	46.42	897298.0
2008-04-18 09:00:00	QQQ	ETF	46.42	46.55	46.39	46.5	4742431.0
2008-04-18 09:30:00	QQQ	ETF	46.51	46.53	46.25	46.28	20383611.0
2008-04-18 10:00:00	QQQ	ETF	46.28	46.43	46.22	46.34	9597464.0
2008-04-18 10:30:00	QQQ	ETF	46.35	46.56	46.31	46.53	6533355.0
2008-04-18 11:00:00	QQQ	ETF	46.53	46.71	46.5	46.68	8643344.0
2008-04-18 11:30:00	QQQ	ETF	46.6799	46.78	46.62	46.77	7020911.0
2008-04-18 12:00:00	QQQ	ETF	46.76	46.9	46.74	46.85	7312122.0
2008-04-18 12:30:00	QQQ	ETF	46.86	46.9	46.77	46.8	5596773.0
2008-04-18 13:00:00	QQQ	ETF	46.8001	46.93	46.79	46.9119	4300063.0
2008-04-18 13:30:00	QQQ	ETF	46.91	46.92	46.82	46.8699	4269844.0
2008-04-18 14:00:00	QQQ	ETF	46.87	46.88	46.72	46.76	8486410.0

> showing 50 of 5,896 rows — these rows as CSV

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