PREVIEW / etf_30min / 2005-08-19

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-08-19.parquet
  size:    43 KB
  rows:    1,602

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-19 06:30:00	SPY	ETF	122.5	122.5	122.5	122.5	400.0
2005-08-19 07:00:00	SPY	ETF	122.46	122.46	122.42	122.42	52800.0
2005-08-19 07:30:00	SPY	ETF	122.43	122.43	122.43	122.43	9800.0
2005-08-19 08:00:00	SPY	ETF	122.41	122.45	122.36	122.4	52900.0
2005-08-19 08:30:00	SPY	ETF	122.41	122.5	122.41	122.49	68900.0
2005-08-19 09:00:00	SPY	ETF	122.51	122.64	122.51	122.63	345300.0
2005-08-19 09:30:00	SPY	ETF	122.63	122.64	122.4	122.55	4606500.0
2005-08-19 10:00:00	SPY	ETF	122.54	122.82	122.5	122.77	4087600.0
2005-08-19 10:30:00	SPY	ETF	122.76	122.77	122.59	122.68	2348100.0
2005-08-19 11:00:00	SPY	ETF	122.66	122.75	122.56	122.64	2411200.0
2005-08-19 11:30:00	SPY	ETF	122.64	122.8	122.59	122.59	2002400.0
2005-08-19 12:00:00	SPY	ETF	122.6	122.74	122.51	122.53	1321900.0
2005-08-19 12:30:00	SPY	ETF	122.54	122.58	122.44	122.54	1817400.0
2005-08-19 13:00:00	SPY	ETF	122.54	122.55	122.27	122.44	5336500.0
2005-08-19 13:30:00	SPY	ETF	122.43	122.52	122.4	122.48	1617500.0
2005-08-19 14:00:00	SPY	ETF	122.5	122.56	122.45	122.45	1728400.0
2005-08-19 14:30:00	SPY	ETF	122.45	122.48	122.24	122.32	3831900.0
2005-08-19 15:00:00	SPY	ETF	122.33	122.48	122.31	122.47	1911300.0
2005-08-19 15:30:00	SPY	ETF	122.46	122.51	122.2	122.27	3257800.0
2005-08-19 16:00:00	SPY	ETF	122.27	122.52	122.22	122.42	1938900.0
2005-08-19 16:30:00	SPY	ETF	122.44	122.47	122.38	122.47	41800.0
2005-08-19 17:00:00	SPY	ETF	122.47	122.54	122.47	122.54	8900.0
2005-08-19 17:30:00	SPY	ETF	122.55	122.62	122.37	122.4	45000.0
2005-08-19 18:00:00	SPY	ETF	122.44	122.46	122.43	122.43	300.0
2005-08-19 18:30:00	SPY	ETF	122.48	122.48	122.48	122.48	1200.0
2005-08-19 09:30:00	QQQ	ETF	38.89	38.91	38.79	38.89	6459900.0
2005-08-19 10:00:00	QQQ	ETF	38.89	38.99	38.86	38.96	6494600.0
2005-08-19 10:30:00	QQQ	ETF	38.95	38.97	38.91	38.94	2601000.0
2005-08-19 11:00:00	QQQ	ETF	38.94	38.96	38.91	38.93	2517300.0
2005-08-19 11:30:00	QQQ	ETF	38.93	39.0	38.92	38.92	3308900.0
2005-08-19 12:00:00	QQQ	ETF	38.92	38.93	38.88	38.88	2101600.0
2005-08-19 12:30:00	QQQ	ETF	38.89	38.9	38.86	38.88	2257100.0
2005-08-19 13:00:00	QQQ	ETF	38.89	38.9	38.81	38.87	3092100.0
2005-08-19 13:30:00	QQQ	ETF	38.87	38.89	38.84	38.85	1693200.0
2005-08-19 14:00:00	QQQ	ETF	38.85	38.87	38.84	38.85	2031400.0
2005-08-19 14:30:00	QQQ	ETF	38.86	38.87	38.8	38.81	4705200.0
2005-08-19 15:00:00	QQQ	ETF	38.81	38.89	38.81	38.88	3300600.0
2005-08-19 15:30:00	QQQ	ETF	38.88	38.9	38.81	38.82	6340100.0
2005-08-19 07:30:00	IWM	ETF	64.98	64.99	64.97	64.97	22900.0
2005-08-19 08:00:00	IWM	ETF	64.95	64.97	64.93	64.93	15000.0
2005-08-19 08:30:00	IWM	ETF	64.94	65.0	64.92	65.0	9200.0
2005-08-19 09:00:00	IWM	ETF	65.01	65.07	64.77	65.05	10400.0
2005-08-19 09:30:00	IWM	ETF	65.05	65.05	64.71	64.9	1893800.0
2005-08-19 10:00:00	IWM	ETF	64.9	65.1	64.77	65.04	1576300.0
2005-08-19 10:30:00	IWM	ETF	65.04	65.07	64.95	65.05	655500.0
2005-08-19 11:00:00	IWM	ETF	65.05	65.1	64.95	65.0	831000.0
2005-08-19 11:30:00	IWM	ETF	65.0	65.16	64.96	65.02	889800.0
2005-08-19 12:00:00	IWM	ETF	65.02	65.1	65.01	65.03	1829800.0
2005-08-19 12:30:00	IWM	ETF	65.03	65.06	64.98	65.05	436200.0
2005-08-19 13:00:00	IWM	ETF	65.04	65.08	64.9	64.96	1869600.0

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

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