PREVIEW / etf_1hour / 2004-03-16

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-03-16.parquet
  size:    25 KB
  rows:    701

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
2004-03-16 08:00:00	SPY	ETF	111.62	111.89	111.62	111.79	134600.0
2004-03-16 09:00:00	SPY	ETF	111.79	112.06	111.73	111.85	6090700.0
2004-03-16 10:00:00	SPY	ETF	111.85	111.98	111.67	111.78	6963900.0
2004-03-16 11:00:00	SPY	ETF	111.78	111.89	111.54	111.67	5392400.0
2004-03-16 12:00:00	SPY	ETF	111.68	111.68	111.29	111.36	5534400.0
2004-03-16 13:00:00	SPY	ETF	111.37	111.69	111.31	111.53	2966200.0
2004-03-16 14:00:00	SPY	ETF	111.54	112.0	110.87	110.99	15433800.0
2004-03-16 15:00:00	SPY	ETF	110.96	111.95	110.84	111.73	10609100.0
2004-03-16 16:00:00	SPY	ETF	111.72	111.87	111.64	111.74	2417700.0
2004-03-16 17:00:00	SPY	ETF	111.7	111.79	111.7	111.79	1801400.0
2004-03-16 18:00:00	SPY	ETF	111.76	111.76	111.71	111.71	1000.0
2004-03-16 19:00:00	SPY	ETF	111.77	111.78	111.75	111.75	5400.0
2004-03-16 08:00:00	QQQ	ETF	35.04	35.18	35.04	35.12	337000.0
2004-03-16 09:00:00	QQQ	ETF	35.12	35.25	35.1	35.16	17401500.0
2004-03-16 10:00:00	QQQ	ETF	35.17	35.22	35.039	35.089	14289800.0
2004-03-16 11:00:00	QQQ	ETF	35.087	35.15	34.948	35.01	11280300.0
2004-03-16 12:00:00	QQQ	ETF	35.01	35.03	34.83	34.85	11379100.0
2004-03-16 13:00:00	QQQ	ETF	34.85	35.03	34.84	34.969	9120800.0
2004-03-16 14:00:00	QQQ	ETF	34.969	35.11	34.68	34.7	20851400.0
2004-03-16 15:00:00	QQQ	ETF	34.7	35.109	34.63	35.004	26825000.0
2004-03-16 16:00:00	QQQ	ETF	35.005	35.01	34.92	34.965	2929300.0
2004-03-16 17:00:00	QQQ	ETF	34.96	34.99	34.952	34.98	5766700.0
2004-03-16 18:00:00	QQQ	ETF	34.98	34.98	34.96	34.98	59900.0
2004-03-16 19:00:00	QQQ	ETF	34.98	35.02	34.98	35.01	28600.0
2004-03-16 08:00:00	IWM	ETF	57.055	57.055	56.99	57.0	50000.0
2004-03-16 09:00:00	IWM	ETF	57.025	57.265	56.96	56.98	3347600.0
2004-03-16 10:00:00	IWM	ETF	56.97	57.06	56.655	56.86	2485600.0
2004-03-16 11:00:00	IWM	ETF	56.835	56.835	56.55	56.685	1655600.0
2004-03-16 12:00:00	IWM	ETF	56.7	56.7	56.01	56.05	6306200.0
2004-03-16 13:00:00	IWM	ETF	56.055	56.355	56.04	56.29	4305400.0
2004-03-16 14:00:00	IWM	ETF	56.29	56.605	56.025	56.175	7023400.0
2004-03-16 15:00:00	IWM	ETF	56.1	56.79	56.02	56.635	5443400.0
2004-03-16 16:00:00	IWM	ETF	56.63	56.775	56.175	56.655	974200.0
2004-03-16 17:00:00	IWM	ETF	56.519	56.65	56.5	56.5	1257000.0
2004-03-16 08:00:00	DIA	ETF	101.81	102.03	101.81	101.95	29700.0
2004-03-16 09:00:00	DIA	ETF	101.93	102.36	101.84	102.0	1303900.0
2004-03-16 10:00:00	DIA	ETF	102.01	102.25	101.92	102.06	843400.0
2004-03-16 11:00:00	DIA	ETF	102.06	102.2	101.93	102.02	705200.0
2004-03-16 12:00:00	DIA	ETF	102.01	102.03	101.6	101.63	692700.0
2004-03-16 13:00:00	DIA	ETF	101.67	101.95	101.6	101.86	666700.0
2004-03-16 14:00:00	DIA	ETF	101.88	102.24	101.25	101.34	2012200.0
2004-03-16 15:00:00	DIA	ETF	101.34	102.28	101.23	102.11	2002200.0
2004-03-16 16:00:00	DIA	ETF	102.12	102.21	102.03	102.1	137400.0
2004-03-16 17:00:00	DIA	ETF	102.14	102.14	102.14	102.14	800.0
2004-03-16 18:00:00	DIA	ETF	102.11	102.15	102.1	102.15	400.0
2004-03-16 09:00:00	TLT	ETF	90.29	90.32	90.27	90.32	8400.0
2004-03-16 10:00:00	TLT	ETF	90.28	90.33	90.21	90.3	138100.0
2004-03-16 11:00:00	TLT	ETF	90.29	90.31	90.05	90.15	73900.0
2004-03-16 12:00:00	TLT	ETF	90.22	90.41	90.22	90.28	107800.0
2004-03-16 13:00:00	TLT	ETF	90.29	90.37	90.27	90.34	130000.0

> showing 50 of 701 rows — these rows as CSV

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