PREVIEW / etf_30min / 2005-08-22

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-22.parquet
  size:    46 KB
  rows:    1,607

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
2005-08-22 06:30:00	SPY	ETF	122.73	122.73	122.73	122.73	27300.0
2005-08-22 07:00:00	SPY	ETF	122.77	122.82	122.77	122.82	1200.0
2005-08-22 07:30:00	SPY	ETF	122.82	122.82	122.78	122.78	22500.0
2005-08-22 08:00:00	SPY	ETF	122.7	122.76	122.62	122.75	587500.0
2005-08-22 08:30:00	SPY	ETF	122.73	122.78	122.29	122.73	308400.0
2005-08-22 09:00:00	SPY	ETF	122.26	122.72	122.26	122.6	312600.0
2005-08-22 09:30:00	SPY	ETF	122.58	123.06	122.51	123.05	6862200.0
2005-08-22 10:00:00	SPY	ETF	123.04	123.23	123.03	123.07	5863300.0
2005-08-22 10:30:00	SPY	ETF	123.05	123.2	123.0	123.12	3737400.0
2005-08-22 11:00:00	SPY	ETF	123.12	123.15	122.92	122.98	3979600.0
2005-08-22 11:30:00	SPY	ETF	122.98	123.02	122.67	122.73	3679800.0
2005-08-22 12:00:00	SPY	ETF	122.73	122.85	122.32	122.38	7354400.0
2005-08-22 12:30:00	SPY	ETF	122.37	122.4	122.08	122.21	4094500.0
2005-08-22 13:00:00	SPY	ETF	122.21	122.72	121.88	122.25	7363200.0
2005-08-22 13:30:00	SPY	ETF	122.25	122.47	122.2	122.38	4743400.0
2005-08-22 14:00:00	SPY	ETF	122.38	122.39	122.16	122.23	3321200.0
2005-08-22 14:30:00	SPY	ETF	122.23	122.36	122.1	122.23	3561500.0
2005-08-22 15:00:00	SPY	ETF	122.23	122.31	122.08	122.21	2712600.0
2005-08-22 15:30:00	SPY	ETF	122.21	122.49	122.2	122.47	5678600.0
2005-08-22 16:00:00	SPY	ETF	122.48	122.52	122.37	122.44	214500.0
2005-08-22 16:30:00	SPY	ETF	122.45	122.5	122.43	122.5	165500.0
2005-08-22 17:00:00	SPY	ETF	122.52	122.52	122.5	122.52	2700.0
2005-08-22 17:30:00	SPY	ETF	122.5	122.5	122.5	122.5	200.0
2005-08-22 18:00:00	SPY	ETF	122.5	122.5	122.5	122.5	200.0
2005-08-22 19:30:00	SPY	ETF	122.53	122.55	122.53	122.55	1800.0
2005-08-22 09:30:00	QQQ	ETF	38.89	39.08	38.86	39.05	11736200.0
2005-08-22 10:00:00	QQQ	ETF	39.05	39.18	39.05	39.13	9905500.0
2005-08-22 10:30:00	QQQ	ETF	39.12	39.17	39.08	39.11	7472500.0
2005-08-22 11:00:00	QQQ	ETF	39.12	39.12	38.98	39.02	5412500.0
2005-08-22 11:30:00	QQQ	ETF	39.02	39.03	38.9	38.91	5904300.0
2005-08-22 12:00:00	QQQ	ETF	38.92	38.92	38.75	38.77	7917100.0
2005-08-22 12:30:00	QQQ	ETF	38.76	38.77	38.61	38.65	8666600.0
2005-08-22 13:00:00	QQQ	ETF	38.66	38.71	38.6	38.71	4855100.0
2005-08-22 13:30:00	QQQ	ETF	38.71	38.82	38.68	38.8	5466500.0
2005-08-22 14:00:00	QQQ	ETF	38.79	38.8	38.7	38.74	3010100.0
2005-08-22 14:30:00	QQQ	ETF	38.74	38.79	38.7	38.77	3487200.0
2005-08-22 15:00:00	QQQ	ETF	38.76	38.78	38.69	38.73	3153500.0
2005-08-22 15:30:00	QQQ	ETF	38.73	38.84	38.73	38.84	6444400.0
2005-08-22 07:30:00	IWM	ETF	65.33	65.33	65.32	65.32	2000.0
2005-08-22 08:00:00	IWM	ETF	65.2	65.24	65.2	65.24	600.0
2005-08-22 08:30:00	IWM	ETF	65.24	65.28	65.24	65.26	29800.0
2005-08-22 09:00:00	IWM	ETF	65.26	65.26	65.16	65.22	50800.0
2005-08-22 09:30:00	IWM	ETF	65.24	65.44	65.1	65.37	2943800.0
2005-08-22 10:00:00	IWM	ETF	65.37	65.5	65.27	65.31	1935000.0
2005-08-22 10:30:00	IWM	ETF	65.34	65.4	65.2	65.37	1024700.0
2005-08-22 11:00:00	IWM	ETF	65.37	65.37	65.17	65.26	2445400.0
2005-08-22 11:30:00	IWM	ETF	65.26	65.33	65.18	65.19	891800.0
2005-08-22 12:00:00	IWM	ETF	65.18	65.22	65.0	65.02	1118100.0
2005-08-22 12:30:00	IWM	ETF	65.02	65.06	64.88	65.0	1224200.0
2005-08-22 13:00:00	IWM	ETF	64.99	65.16	64.87	65.14	1502600.0

> showing 50 of 1,607 rows — these rows as CSV

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