PREVIEW / etf_30min / 2008-01-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-01-10.parquet
  size:    157 KB
  rows:    5,623

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-01-10 04:00:00	SPY	ETF	140.03	140.03	140.03	140.03	100.0
2008-01-10 04:30:00	SPY	ETF	139.72	140.05	139.72	140.05	12000.0
2008-01-10 05:00:00	SPY	ETF	139.97	139.97	139.97	139.97	1000.0
2008-01-10 05:30:00	SPY	ETF	140.12	140.12	140.12	140.12	1000.0
2008-01-10 06:00:00	SPY	ETF	140.07	140.09	140.0	140.0	128800.0
2008-01-10 06:30:00	SPY	ETF	139.95	140.11	139.86	140.11	168500.0
2008-01-10 07:00:00	SPY	ETF	139.91	140.25	139.81	140.2	457200.0
2008-01-10 07:30:00	SPY	ETF	140.25	140.4	140.1	140.24	291500.0
2008-01-10 08:00:00	SPY	ETF	140.18	140.35	139.83	139.85	2165800.0
2008-01-10 08:30:00	SPY	ETF	139.89	140.26	139.51	139.78	5281600.0
2008-01-10 09:00:00	SPY	ETF	139.79	139.83	139.56	139.7	3638862.0
2008-01-10 09:30:00	SPY	ETF	139.68	140.12	139.37	139.98	22208964.0
2008-01-10 10:00:00	SPY	ETF	139.98	140.58	139.92	140.2	16765465.0
2008-01-10 10:30:00	SPY	ETF	140.2	140.78	140.0	140.16	17089005.0
2008-01-10 11:00:00	SPY	ETF	140.16	140.28	139.83	140.12	11806549.0
2008-01-10 11:30:00	SPY	ETF	140.13	140.23	139.66	140.17	7734303.0
2008-01-10 12:00:00	SPY	ETF	140.16	142.29	139.94	141.27	44347772.0
2008-01-10 12:30:00	SPY	ETF	141.27	141.62	140.53	141.39	34377756.0
2008-01-10 13:00:00	SPY	ETF	141.39	141.57	140.7	141.15	14995673.0
2008-01-10 13:30:00	SPY	ETF	141.15	141.284	139.98	140.54	21946937.0
2008-01-10 14:00:00	SPY	ETF	140.54	141.5	140.13	141.17	24715204.0
2008-01-10 14:30:00	SPY	ETF	141.15	142.3	141.05	142.13	24462326.0
2008-01-10 15:00:00	SPY	ETF	142.13	142.77	142.02	142.56	19090977.0
2008-01-10 15:30:00	SPY	ETF	142.56	142.8	141.71	141.8	40177621.0
2008-01-10 16:00:00	SPY	ETF	141.82	141.96	139.76	141.25	8922900.0
2008-01-10 16:30:00	SPY	ETF	141.24	141.25	140.77	141.16	12042400.0
2008-01-10 17:00:00	SPY	ETF	141.16	141.29	141.11	141.17	1109000.0
2008-01-10 17:30:00	SPY	ETF	141.17	141.29	141.11	141.23	1023500.0
2008-01-10 18:00:00	SPY	ETF	141.23	141.49	141.19	141.43	34200.0
2008-01-10 18:30:00	SPY	ETF	141.43	141.54	141.39	141.44	13500.0
2008-01-10 19:00:00	SPY	ETF	141.43	141.43	141.2	141.2	11900.0
2008-01-10 19:30:00	SPY	ETF	141.2	141.22	141.19	141.22	13600.0
2008-01-10 04:30:00	QQQ	ETF	47.6	47.6	47.6	47.6	200.0
2008-01-10 05:30:00	QQQ	ETF	47.64	47.66	47.64	47.66	1000.0
2008-01-10 06:00:00	QQQ	ETF	47.65	47.69	47.64	47.64	31700.0
2008-01-10 06:30:00	QQQ	ETF	47.64	47.64	47.54	47.55	164300.0
2008-01-10 07:00:00	QQQ	ETF	47.62	47.75	47.55	47.74	435773.0
2008-01-10 07:30:00	QQQ	ETF	47.73	47.81	47.69	47.69	173992.0
2008-01-10 08:00:00	QQQ	ETF	47.71	47.75	47.56	47.6	1229946.0
2008-01-10 08:30:00	QQQ	ETF	47.63	47.95	47.37	47.5	3512078.0
2008-01-10 09:00:00	QQQ	ETF	47.5	47.5	47.35	47.42	3312415.0
2008-01-10 09:30:00	QQQ	ETF	47.41	47.6	47.29	47.45	20792641.0
2008-01-10 10:00:00	QQQ	ETF	47.45	47.75	47.4	47.49	22206855.0
2008-01-10 10:30:00	QQQ	ETF	47.49	47.678	47.39	47.5	13305164.0
2008-01-10 11:00:00	QQQ	ETF	47.5	47.62	47.4	47.58	6341667.0
2008-01-10 11:30:00	QQQ	ETF	47.58	47.63	47.45	47.59	5497026.0
2008-01-10 12:00:00	QQQ	ETF	47.5801	48.35	47.53	47.95	29664041.0
2008-01-10 12:30:00	QQQ	ETF	47.95	48.15	47.64	48.01	27604786.0
2008-01-10 13:00:00	QQQ	ETF	48.0	48.09	47.86	47.99	11763600.0
2008-01-10 13:30:00	QQQ	ETF	47.99	48.06	47.48	47.72	18739728.0

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

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