PREVIEW / etf_1hour / 2004-10-20

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-10-20.parquet
  size:    26 KB
  rows:    711

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-10-20 08:00:00	SPY	ETF	110.26	110.4	110.2	110.31	91700.0
2004-10-20 09:00:00	SPY	ETF	110.3	110.52	110.25	110.4	5746500.0
2004-10-20 10:00:00	SPY	ETF	110.42	110.43	109.75	110.1	13022600.0
2004-10-20 11:00:00	SPY	ETF	110.09	110.47	110.07	110.26	9513500.0
2004-10-20 12:00:00	SPY	ETF	110.25	110.82	110.15	110.64	8577900.0
2004-10-20 13:00:00	SPY	ETF	110.6416	110.71	110.36	110.36	2690300.0
2004-10-20 14:00:00	SPY	ETF	110.35	110.67	110.23	110.6	5851400.0
2004-10-20 15:00:00	SPY	ETF	110.61	110.81	110.32	110.72	5294300.0
2004-10-20 16:00:00	SPY	ETF	110.72	110.77	110.52	110.59	4119800.0
2004-10-20 17:00:00	SPY	ETF	110.61	110.7	110.61	110.66	72400.0
2004-10-20 18:00:00	SPY	ETF	110.66	110.72	110.63	110.7	15300.0
2004-10-20 19:00:00	SPY	ETF	110.7	110.73	110.69	110.71	1600.0
2004-10-20 08:00:00	QQQ	ETF	35.72	35.81	35.71	35.8	164300.0
2004-10-20 09:00:00	QQQ	ETF	35.79	35.94	35.75	35.91	12612200.0
2004-10-20 10:00:00	QQQ	ETF	35.91	35.99	35.65	35.88	21976300.0
2004-10-20 11:00:00	QQQ	ETF	35.882	36.081	35.86	35.98	19005400.0
2004-10-20 12:00:00	QQQ	ETF	35.971	36.23	35.94	36.14	11777600.0
2004-10-20 13:00:00	QQQ	ETF	36.14	36.19	35.96	35.97	8491500.0
2004-10-20 14:00:00	QQQ	ETF	35.98	36.121	35.93	36.042	11916100.0
2004-10-20 15:00:00	QQQ	ETF	36.05	36.12	35.91	36.093	15182000.0
2004-10-20 16:00:00	QQQ	ETF	36.1	36.14	36.02	36.11	2951500.0
2004-10-20 17:00:00	QQQ	ETF	36.108	36.24	36.108	36.2	300100.0
2004-10-20 18:00:00	QQQ	ETF	36.19	36.23	36.17	36.19	152300.0
2004-10-20 19:00:00	QQQ	ETF	36.18	36.18	36.15	36.16	16500.0
2004-10-20 08:00:00	IWM	ETF	56.24	56.24	56.165	56.18	43800.0
2004-10-20 09:00:00	IWM	ETF	56.165	56.54	56.165	56.44	1449800.0
2004-10-20 10:00:00	IWM	ETF	56.445	56.465	56.035	56.195	3309600.0
2004-10-20 11:00:00	IWM	ETF	56.25	56.595	56.2	56.48	2180600.0
2004-10-20 12:00:00	IWM	ETF	56.5	56.945	56.435	56.855	2820000.0
2004-10-20 13:00:00	IWM	ETF	56.85	56.875	56.625	56.625	893800.0
2004-10-20 14:00:00	IWM	ETF	56.625	56.815	56.625	56.78	681000.0
2004-10-20 15:00:00	IWM	ETF	56.77	56.84	56.6	56.76	2180000.0
2004-10-20 16:00:00	IWM	ETF	56.77	56.82	56.675	56.675	637800.0
2004-10-20 08:00:00	DIA	ETF	98.75	98.88	98.71	98.86	11400.0
2004-10-20 09:00:00	DIA	ETF	98.87	99.01	98.8	98.89	924500.0
2004-10-20 10:00:00	DIA	ETF	98.91	98.92	98.2	98.45	2101500.0
2004-10-20 11:00:00	DIA	ETF	98.49	98.8	98.42	98.61	1565000.0
2004-10-20 12:00:00	DIA	ETF	98.6	99.09	98.5	98.94	1412700.0
2004-10-20 13:00:00	DIA	ETF	98.94	99.03	98.6	98.62	582600.0
2004-10-20 14:00:00	DIA	ETF	98.62	98.87	98.45	98.81	1129800.0
2004-10-20 15:00:00	DIA	ETF	98.81	99.06	98.57	99.01	1080100.0
2004-10-20 16:00:00	DIA	ETF	99.03	99.03	98.84	98.93	295600.0
2004-10-20 17:00:00	DIA	ETF	98.92	98.95	98.9	98.9	5100.0
2004-10-20 18:00:00	DIA	ETF	99.05	99.05	99.05	99.05	600.0
2004-10-20 08:00:00	TLT	ETF	89.26	89.39	89.24	89.26	18600.0
2004-10-20 09:00:00	TLT	ETF	89.26	89.35	89.26	89.32	148400.0
2004-10-20 10:00:00	TLT	ETF	89.35	89.61	89.34	89.51	266900.0
2004-10-20 11:00:00	TLT	ETF	89.5	89.51	89.28	89.33	269200.0
2004-10-20 12:00:00	TLT	ETF	89.3	89.4	89.2	89.24	78300.0
2004-10-20 13:00:00	TLT	ETF	89.26	89.42	89.23	89.42	28600.0

> showing 50 of 711 rows — these rows as CSV

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