PREVIEW / etf_30min / 2005-07-19

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-07-19.parquet
  size:    46 KB
  rows:    1,647

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-07-19 04:30:00	SPY	ETF	122.58	122.58	122.58	122.58	16400.0
2005-07-19 07:00:00	SPY	ETF	122.6	122.61	122.6	122.6	800.0
2005-07-19 07:30:00	SPY	ETF	122.6	122.73	122.58	122.71	39700.0
2005-07-19 08:00:00	SPY	ETF	122.7	122.79	122.68	122.79	166100.0
2005-07-19 08:30:00	SPY	ETF	122.74	122.76	122.72	122.72	24500.0
2005-07-19 09:00:00	SPY	ETF	122.72	122.77	122.72	122.74	28600.0
2005-07-19 09:30:00	SPY	ETF	122.71	122.88	122.41	122.66	6141900.0
2005-07-19 10:00:00	SPY	ETF	122.65	123.03	122.49	122.98	6541200.0
2005-07-19 10:30:00	SPY	ETF	122.98	123.0	122.74	122.78	2775800.0
2005-07-19 11:00:00	SPY	ETF	122.79	122.82	122.5	122.61	4067600.0
2005-07-19 11:30:00	SPY	ETF	122.61	122.71	122.56	122.7	2093700.0
2005-07-19 12:00:00	SPY	ETF	122.69	122.74	122.53	122.62	1151900.0
2005-07-19 12:30:00	SPY	ETF	122.61	122.82	122.59	122.81	1348400.0
2005-07-19 13:00:00	SPY	ETF	122.81	122.87	122.72	122.75	2248500.0
2005-07-19 13:30:00	SPY	ETF	122.75	122.86	122.66	122.76	1516400.0
2005-07-19 14:00:00	SPY	ETF	122.76	122.85	122.6	122.84	17543100.0
2005-07-19 14:30:00	SPY	ETF	122.85	122.91	122.73	122.83	2041000.0
2005-07-19 15:00:00	SPY	ETF	122.83	122.95	122.75	122.9	2062800.0
2005-07-19 15:30:00	SPY	ETF	122.91	123.11	122.9	122.99	6035700.0
2005-07-19 16:00:00	SPY	ETF	123.01	123.08	122.71	122.8	882600.0
2005-07-19 16:30:00	SPY	ETF	122.8	122.86	122.53	122.53	1394100.0
2005-07-19 17:00:00	SPY	ETF	122.52	122.61	122.52	122.59	169300.0
2005-07-19 17:30:00	SPY	ETF	122.61	122.67	122.6	122.6	7800.0
2005-07-19 18:00:00	SPY	ETF	122.6	122.63	122.56	122.56	6600.0
2005-07-19 18:30:00	SPY	ETF	122.6	122.6	122.56	122.56	8200.0
2005-07-19 19:00:00	SPY	ETF	122.63	122.63	122.61	122.61	2400.0
2005-07-19 09:30:00	QQQ	ETF	38.92	38.96	38.84	38.93	10598400.0
2005-07-19 10:00:00	QQQ	ETF	38.93	39.13	38.87	39.12	10959200.0
2005-07-19 10:30:00	QQQ	ETF	39.11	39.13	39.02	39.06	6068600.0
2005-07-19 11:00:00	QQQ	ETF	39.06	39.07	38.97	39.03	4568400.0
2005-07-19 11:30:00	QQQ	ETF	39.02	39.08	39.01	39.06	2694300.0
2005-07-19 12:00:00	QQQ	ETF	39.06	39.08	39.02	39.06	1887000.0
2005-07-19 12:30:00	QQQ	ETF	39.05	39.13	39.05	39.13	2128600.0
2005-07-19 13:00:00	QQQ	ETF	39.13	39.16	39.11	39.12	3704600.0
2005-07-19 13:30:00	QQQ	ETF	39.12	39.16	39.08	39.12	2125000.0
2005-07-19 14:00:00	QQQ	ETF	39.12	39.14	39.05	39.13	2963000.0
2005-07-19 14:30:00	QQQ	ETF	39.13	39.17	39.11	39.14	4096900.0
2005-07-19 15:00:00	QQQ	ETF	39.14	39.17	39.11	39.13	5013200.0
2005-07-19 15:30:00	QQQ	ETF	39.14	39.2	39.13	39.18	11347900.0
2005-07-19 07:00:00	IWM	ETF	65.75	65.75	65.75	65.75	100.0
2005-07-19 07:30:00	IWM	ETF	65.8	65.8	65.8	65.8	100.0
2005-07-19 08:00:00	IWM	ETF	65.89	65.89	65.84	65.84	3400.0
2005-07-19 08:30:00	IWM	ETF	65.86	65.88	65.84	65.87	6100.0
2005-07-19 09:00:00	IWM	ETF	65.85	65.88	65.8	65.87	175200.0
2005-07-19 09:30:00	IWM	ETF	65.89	66.03	65.75	65.92	2105400.0
2005-07-19 10:00:00	IWM	ETF	65.93	66.26	65.77	66.23	1934800.0
2005-07-19 10:30:00	IWM	ETF	66.23	66.27	66.08	66.16	1035800.0
2005-07-19 11:00:00	IWM	ETF	66.16	66.17	65.88	65.96	835900.0
2005-07-19 11:30:00	IWM	ETF	65.96	66.15	65.94	66.14	481300.0
2005-07-19 12:00:00	IWM	ETF	66.15	66.15	66.05	66.11	329500.0

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

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