PREVIEW / etf_1hour / 2007-04-11

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-04-11.parquet
  size:    69 KB
  rows:    2,182

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
2007-04-11 06:00:00	SPY	ETF	144.71	144.78	144.71	144.78	10000.0
2007-04-11 07:00:00	SPY	ETF	144.77	144.77	144.74	144.77	22300.0
2007-04-11 08:00:00	SPY	ETF	144.74	144.89	144.74	144.88	412300.0
2007-04-11 09:00:00	SPY	ETF	144.88	144.89	144.41	144.49	8567887.0
2007-04-11 10:00:00	SPY	ETF	144.49	144.61	143.81	143.96	20146882.0
2007-04-11 11:00:00	SPY	ETF	143.96	144.17	143.94	144.12	12082947.0
2007-04-11 12:00:00	SPY	ETF	144.12	144.28	144.09	144.2	7176293.0
2007-04-11 13:00:00	SPY	ETF	144.2	144.45	144.13	144.23	8173340.0
2007-04-11 14:00:00	SPY	ETF	144.23	144.23	143.54	143.78	29657140.0
2007-04-11 15:00:00	SPY	ETF	143.79	144.03	143.69	143.83	13266142.0
2007-04-11 16:00:00	SPY	ETF	143.84	144.02	143.81	144.0	4728600.0
2007-04-11 17:00:00	SPY	ETF	143.898	143.98	143.85	143.85	214500.0
2007-04-11 18:00:00	SPY	ETF	143.9	143.94	143.9	143.92	176100.0
2007-04-11 19:00:00	SPY	ETF	143.92	143.95	143.92	143.95	2900.0
2007-04-11 07:00:00	QQQ	ETF	44.7	44.7	44.66	44.68	177725.0
2007-04-11 08:00:00	QQQ	ETF	44.67	44.71	44.67	44.68	304312.0
2007-04-11 09:00:00	QQQ	ETF	44.68	44.69	44.44	44.47	18062219.0
2007-04-11 10:00:00	QQQ	ETF	44.48	44.52	44.2	44.26	24467000.0
2007-04-11 11:00:00	QQQ	ETF	44.25	44.37	44.24	44.36	11117300.0
2007-04-11 12:00:00	QQQ	ETF	44.35	44.42	44.31	44.35	7309200.0
2007-04-11 13:00:00	QQQ	ETF	44.35	44.46	44.33	44.37	7977900.0
2007-04-11 14:00:00	QQQ	ETF	44.36	44.37	44.07	44.17	24350700.0
2007-04-11 15:00:00	QQQ	ETF	44.17	44.27	44.13	44.21	13046200.0
2007-04-11 16:00:00	QQQ	ETF	44.22	44.24	44.17	44.2	4328699.0
2007-04-11 17:00:00	QQQ	ETF	44.21	44.21	44.17	44.2	35550.0
2007-04-11 18:00:00	QQQ	ETF	44.17	44.2	44.16	44.16	2893810.0
2007-04-11 19:00:00	QQQ	ETF	44.17	44.2	44.17	44.2	18100.0
2007-04-11 08:00:00	IWM	ETF	80.8	80.9	80.8	80.9	2257500.0
2007-04-11 09:00:00	IWM	ETF	80.88	80.9	80.46	80.51	5222684.0
2007-04-11 10:00:00	IWM	ETF	80.52	80.56	79.92	80.02	10520729.0
2007-04-11 11:00:00	IWM	ETF	80.03	80.3	80.02	80.26	7015039.0
2007-04-11 12:00:00	IWM	ETF	80.25	80.39	80.24	80.34	3609706.0
2007-04-11 13:00:00	IWM	ETF	80.335	80.54	80.3	80.41	4678899.0
2007-04-11 14:00:00	IWM	ETF	80.41	80.41	79.8	80.01	13118989.0
2007-04-11 15:00:00	IWM	ETF	80.01	80.27	79.93	80.26	8826499.0
2007-04-11 16:00:00	IWM	ETF	80.26	80.32	80.22	80.27	2724000.0
2007-04-11 17:00:00	IWM	ETF	80.28	80.3	80.28	80.3	2002000.0
2007-04-11 18:00:00	IWM	ETF	80.28	80.28	80.22	80.25	2100.0
2007-04-11 08:00:00	DIA	ETF	125.74	125.82	125.74	125.8	14300.0
2007-04-11 09:00:00	DIA	ETF	125.8	125.81	125.331	125.38	997950.0
2007-04-11 10:00:00	DIA	ETF	125.39	125.49	124.679	124.81	1372978.0
2007-04-11 11:00:00	DIA	ETF	124.81	124.98	124.8	124.98	767591.0
2007-04-11 12:00:00	DIA	ETF	124.98	125.11	124.96	125.05	966545.0
2007-04-11 13:00:00	DIA	ETF	125.05	125.24	125.0	125.02	625200.0
2007-04-11 14:00:00	DIA	ETF	125.02	125.02	124.53	124.71	2895798.0
2007-04-11 15:00:00	DIA	ETF	124.71	124.98	124.63	124.84	1444955.0
2007-04-11 16:00:00	DIA	ETF	124.85	124.91	124.79	124.88	104100.0
2007-04-11 17:00:00	DIA	ETF	124.88	124.88	124.88	124.88	100.0
2007-04-11 18:00:00	DIA	ETF	124.8	124.8	124.76	124.8	290400.0
2007-04-11 07:00:00	GLD	ETF	67.25	67.25	67.25	67.25	500.0

> showing 50 of 2,182 rows — these rows as CSV

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