PREVIEW / etf_30min / 2008-03-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-03-05.parquet
  size:    163 KB
  rows:    5,992

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-03-05 04:00:00	SPY	ETF	132.86	132.86	132.86	132.86	100.0
2008-03-05 05:30:00	SPY	ETF	133.2	133.2	133.15	133.16	13000.0
2008-03-05 06:00:00	SPY	ETF	133.25	133.46	133.25	133.46	1600.0
2008-03-05 06:30:00	SPY	ETF	133.49	133.68	133.49	133.68	159000.0
2008-03-05 07:00:00	SPY	ETF	133.69	133.76	133.45	133.62	337900.0
2008-03-05 07:30:00	SPY	ETF	133.63	133.84	133.41	133.77	681800.0
2008-03-05 08:00:00	SPY	ETF	133.77	133.81	133.1	133.36	2810098.0
2008-03-05 08:30:00	SPY	ETF	133.36	133.42	133.18	133.35	2009700.0
2008-03-05 09:00:00	SPY	ETF	133.31	133.54	132.99	133.4	993100.0
2008-03-05 09:30:00	SPY	ETF	133.41	133.78	133.17	133.68	18274520.0
2008-03-05 10:00:00	SPY	ETF	133.68	134.51	133.63	134.1	27747328.0
2008-03-05 10:30:00	SPY	ETF	134.11	134.27	133.82	134.02	13388321.0
2008-03-05 11:00:00	SPY	ETF	134.02	134.22	133.81	134.14	10310169.0
2008-03-05 11:30:00	SPY	ETF	134.15	134.3	133.8	134.06	9185029.0
2008-03-05 12:00:00	SPY	ETF	134.06	134.77	133.63	133.8	36637823.0
2008-03-05 12:30:00	SPY	ETF	133.8	134.01	133.52	133.85	13205126.0
2008-03-05 13:00:00	SPY	ETF	133.87	134.1	132.98	133.13	24715919.0
2008-03-05 13:30:00	SPY	ETF	133.12	133.16	132.34	132.73	31762057.0
2008-03-05 14:00:00	SPY	ETF	132.74	133.84	132.44	133.09	16992599.0
2008-03-05 14:30:00	SPY	ETF	133.09	133.61	132.91	133.33	13129648.0
2008-03-05 15:00:00	SPY	ETF	133.34	133.44	132.7	133.28	16518948.0
2008-03-05 15:30:00	SPY	ETF	133.28	133.73	133.15	133.7	17589930.0
2008-03-05 16:00:00	SPY	ETF	133.72	134.0	133.01	133.01	6810900.0
2008-03-05 16:30:00	SPY	ETF	133.81	133.85	133.68	133.83	1260900.0
2008-03-05 17:00:00	SPY	ETF	133.83	134.07	133.26	134.07	309600.0
2008-03-05 17:30:00	SPY	ETF	134.06	134.07	133.86	133.93	124400.0
2008-03-05 18:00:00	SPY	ETF	133.98	134.01	133.74	133.8	79400.0
2008-03-05 18:30:00	SPY	ETF	133.568	133.86	133.542	133.72	23000.0
2008-03-05 19:00:00	SPY	ETF	133.71	133.76	133.66	133.66	11200.0
2008-03-05 19:30:00	SPY	ETF	133.66	133.71	133.66	133.69	10800.0
2008-03-05 06:00:00	QQQ	ETF	43.1	43.11	43.1	43.11	2600.0
2008-03-05 06:30:00	QQQ	ETF	43.18	43.18	43.18	43.18	2500.0
2008-03-05 07:00:00	QQQ	ETF	43.19	43.25	43.18	43.22	609207.0
2008-03-05 07:30:00	QQQ	ETF	43.22	43.24	43.16	43.22	277323.0
2008-03-05 08:00:00	QQQ	ETF	43.22	43.22	43.05	43.09	2306545.0
2008-03-05 08:30:00	QQQ	ETF	43.05	43.15	43.01	43.13	2057830.0
2008-03-05 09:00:00	QQQ	ETF	43.11	43.14	42.99	43.0	501609.0
2008-03-05 09:30:00	QQQ	ETF	43.0	43.25	42.96	43.15	20809102.0
2008-03-05 10:00:00	QQQ	ETF	43.15	43.39	43.15	43.24	24795529.0
2008-03-05 10:30:00	QQQ	ETF	43.24	43.37	43.18	43.26	10183494.0
2008-03-05 11:00:00	QQQ	ETF	43.26	43.33	43.2	43.26	5263718.0
2008-03-05 11:30:00	QQQ	ETF	43.25	43.35	43.19	43.25	6009360.0
2008-03-05 12:00:00	QQQ	ETF	43.259	43.54	43.17	43.229	23811843.0
2008-03-05 12:30:00	QQQ	ETF	43.228	43.28	43.14	43.25	5641320.0
2008-03-05 13:00:00	QQQ	ETF	43.25	43.35	42.96	43.07	12531917.0
2008-03-05 13:30:00	QQQ	ETF	43.07	43.07	42.76	42.86	15524082.0
2008-03-05 14:00:00	QQQ	ETF	42.86	43.12	42.75	43.04	10381678.0
2008-03-05 14:30:00	QQQ	ETF	43.04	43.24	42.92	43.11	8304716.0
2008-03-05 15:00:00	QQQ	ETF	43.11	43.11	42.92	43.02	13474443.0
2008-03-05 15:30:00	QQQ	ETF	43.02	43.13	42.98	43.13	14281626.0

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

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