PREVIEW / etf_1hour / 2007-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-26.parquet
  size:    89 KB
  rows:    2,973

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-10-26 04:00:00	SPY	ETF	151.63	151.63	151.63	151.63	400.0
2007-10-26 05:00:00	SPY	ETF	151.6	151.68	151.6	151.68	200.0
2007-10-26 06:00:00	SPY	ETF	151.7	152.13	151.65	152.08	42500.0
2007-10-26 07:00:00	SPY	ETF	152.0	152.0	151.54	151.63	599100.0
2007-10-26 08:00:00	SPY	ETF	151.64	152.82	151.53	152.79	10029400.0
2007-10-26 09:00:00	SPY	ETF	152.79	153.23	152.5	152.63	29080291.0
2007-10-26 10:00:00	SPY	ETF	152.63	153.25	152.26	152.56	30986200.0
2007-10-26 11:00:00	SPY	ETF	152.56	153.15	152.08	152.13	15453250.0
2007-10-26 12:00:00	SPY	ETF	152.13	152.63	151.9	152.56	18245900.0
2007-10-26 13:00:00	SPY	ETF	152.56	152.85	152.35	152.71	12907928.0
2007-10-26 14:00:00	SPY	ETF	152.71	153.46	152.7	153.16	20829700.0
2007-10-26 15:00:00	SPY	ETF	153.16	153.5	152.81	153.45	22436644.0
2007-10-26 16:00:00	SPY	ETF	153.49	153.89	152.6987	153.82	10876200.0
2007-10-26 17:00:00	SPY	ETF	153.8	153.97	153.62	153.73	255700.0
2007-10-26 18:00:00	SPY	ETF	153.77	153.77	153.62	153.75	4700.0
2007-10-26 19:00:00	SPY	ETF	153.78	153.8	153.78	153.8	2500.0
2007-10-26 04:00:00	QQQ	ETF	53.75	53.75	53.75	53.75	800.0
2007-10-26 06:00:00	QQQ	ETF	53.72	53.82	53.72	53.78	256100.0
2007-10-26 07:00:00	QQQ	ETF	53.73	53.75	53.58	53.64	506001.0
2007-10-26 08:00:00	QQQ	ETF	53.62	53.99	53.62	53.9	3769129.0
2007-10-26 09:00:00	QQQ	ETF	53.9	54.2	53.55	53.63	27751479.0
2007-10-26 10:00:00	QQQ	ETF	53.63	53.85	53.51	53.74	28573939.0
2007-10-26 11:00:00	QQQ	ETF	53.74	53.83	53.52	53.53	15108764.0
2007-10-26 12:00:00	QQQ	ETF	53.53	53.74	53.44	53.71	13988417.0
2007-10-26 13:00:00	QQQ	ETF	53.713	53.87	53.64	53.77	12224801.0
2007-10-26 14:00:00	QQQ	ETF	53.7795	54.02	53.76	53.83	15864526.0
2007-10-26 15:00:00	QQQ	ETF	53.83	53.97	53.66	53.95	26937712.0
2007-10-26 16:00:00	QQQ	ETF	53.95	54.05	53.8499	54.0	1631930.0
2007-10-26 17:00:00	QQQ	ETF	54.0	54.03	53.93	53.93	72243.0
2007-10-26 18:00:00	QQQ	ETF	53.95	53.99	53.95	53.98	6065.0
2007-10-26 19:00:00	QQQ	ETF	53.98	53.98	53.93	53.93	6975.0
2007-10-26 05:00:00	IWM	ETF	80.64	80.73	80.64	80.73	400.0
2007-10-26 06:00:00	IWM	ETF	80.91	80.91	80.91	80.91	200.0
2007-10-26 07:00:00	IWM	ETF	80.9	80.9	80.56	80.57	99000.0
2007-10-26 08:00:00	IWM	ETF	80.64	81.34	80.55	81.25	1117000.0
2007-10-26 09:00:00	IWM	ETF	81.25	81.61	81.16	81.21	14204664.0
2007-10-26 10:00:00	IWM	ETF	81.21	81.32	80.85	81.01	9867100.0
2007-10-26 11:00:00	IWM	ETF	81.0	81.13	80.62	80.64	7995600.0
2007-10-26 12:00:00	IWM	ETF	80.64	81.1	80.47	81.06	8984400.0
2007-10-26 13:00:00	IWM	ETF	81.06	81.31	80.95	81.22	4844700.0
2007-10-26 14:00:00	IWM	ETF	81.23	81.86	81.23	81.68	15865200.0
2007-10-26 15:00:00	IWM	ETF	81.68	81.86	81.37	81.86	12899000.0
2007-10-26 16:00:00	IWM	ETF	81.85	82.4	81.79	82.26	4254300.0
2007-10-26 17:00:00	IWM	ETF	82.21	82.22	81.99	81.99	36900.0
2007-10-26 07:00:00	DIA	ETF	137.0	137.0	136.78	136.78	29000.0
2007-10-26 08:00:00	DIA	ETF	136.75	137.54	136.72	137.52	51700.0
2007-10-26 09:00:00	DIA	ETF	137.44	137.69	137.24	137.36	1765507.0
2007-10-26 10:00:00	DIA	ETF	137.36	137.61	137.01	137.28	1896200.0
2007-10-26 11:00:00	DIA	ETF	137.29	137.37	136.96	136.99	877000.0
2007-10-26 12:00:00	DIA	ETF	136.96	137.39	136.84	137.25	669900.0

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

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