PREVIEW / etf_1hour / 2007-01-18

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-18.parquet
  size:    62 KB
  rows:    1,955

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-01-18 04:00:00	SPY	ETF	143.26	143.26	143.26	143.26	400.0
2007-01-18 05:00:00	SPY	ETF	143.28	143.3	143.28	143.3	15000.0
2007-01-18 06:00:00	SPY	ETF	143.26	143.26	143.26	143.26	10000.0
2007-01-18 07:00:00	SPY	ETF	143.11	143.17	143.07	143.1	260700.0
2007-01-18 08:00:00	SPY	ETF	143.05	143.28	143.02	143.27	4143900.0
2007-01-18 09:00:00	SPY	ETF	143.27	143.41	142.98	143.06	8511500.0
2007-01-18 10:00:00	SPY	ETF	143.06	143.16	142.45	142.67	18948200.0
2007-01-18 11:00:00	SPY	ETF	142.68	142.93	142.65	142.75	8260300.0
2007-01-18 12:00:00	SPY	ETF	142.75	143.0	142.63	142.78	5162700.0
2007-01-18 13:00:00	SPY	ETF	142.79	142.85	142.66	142.71	3758400.0
2007-01-18 14:00:00	SPY	ETF	142.7	142.8	142.31	142.36	7643300.0
2007-01-18 15:00:00	SPY	ETF	142.36	142.6	142.31	142.45	7246300.0
2007-01-18 16:00:00	SPY	ETF	142.45	142.53	142.33	142.4	2116900.0
2007-01-18 17:00:00	SPY	ETF	142.4	142.42	142.33	142.35	53900.0
2007-01-18 18:00:00	SPY	ETF	142.35	142.45	142.35	142.42	80000.0
2007-01-18 19:00:00	SPY	ETF	142.42	142.42	142.4	142.4	2600.0
2007-01-18 05:00:00	QQQ	ETF	44.93	44.93	44.92	44.92	10380.0
2007-01-18 06:00:00	QQQ	ETF	44.83	44.83	44.8	44.8	192200.0
2007-01-18 07:00:00	QQQ	ETF	44.81	44.84	44.78	44.78	906611.0
2007-01-18 08:00:00	QQQ	ETF	44.78	44.88	44.75	44.84	6055321.0
2007-01-18 09:00:00	QQQ	ETF	44.84	44.88	44.66	44.68	22367017.0
2007-01-18 10:00:00	QQQ	ETF	44.68	44.84	44.26	44.32	58668300.0
2007-01-18 11:00:00	QQQ	ETF	44.33	44.45	44.32	44.37	18499400.0
2007-01-18 12:00:00	QQQ	ETF	44.37	44.45	41.4	44.32	13627100.0
2007-01-18 13:00:00	QQQ	ETF	44.32	44.43	44.17	44.21	10417000.0
2007-01-18 14:00:00	QQQ	ETF	44.2	44.3	43.95	44.03	21810400.0
2007-01-18 15:00:00	QQQ	ETF	44.03	44.19	43.99	44.07	22638000.0
2007-01-18 16:00:00	QQQ	ETF	44.07	44.135	43.93	44.02	6440809.0
2007-01-18 17:00:00	QQQ	ETF	44.01	44.04	43.95	43.99	423480.0
2007-01-18 18:00:00	QQQ	ETF	44.01	44.05	43.99	44.04	68871.0
2007-01-18 19:00:00	QQQ	ETF	44.02	44.02	43.99	44.0	89223.0
2007-01-18 08:00:00	IWM	ETF	78.16	78.26	78.12	78.18	757800.0
2007-01-18 09:00:00	IWM	ETF	78.28	78.28	77.89	77.96	3846200.0
2007-01-18 10:00:00	IWM	ETF	77.96	77.96	77.31	77.48	14465600.0
2007-01-18 11:00:00	IWM	ETF	77.5	77.75	77.49	77.65	5257600.0
2007-01-18 12:00:00	IWM	ETF	77.65	77.82	77.56	77.59	3644600.0
2007-01-18 13:00:00	IWM	ETF	77.6	77.64	77.42	77.43	3584900.0
2007-01-18 14:00:00	IWM	ETF	77.42	77.64	77.02	77.15	8725000.0
2007-01-18 15:00:00	IWM	ETF	77.15	77.38	77.08	77.17	8511700.0
2007-01-18 16:00:00	IWM	ETF	77.19	79.04	77.1	77.16	1557200.0
2007-01-18 17:00:00	IWM	ETF	77.09	77.09	77.01	77.01	44500.0
2007-01-18 18:00:00	IWM	ETF	77.11	77.92	77.03	77.03	12500.0
2007-01-18 19:00:00	IWM	ETF	77.03	77.03	76.97	76.97	45100.0
2007-01-18 07:00:00	DIA	ETF	125.9	125.9	125.82	125.82	3100.0
2007-01-18 08:00:00	DIA	ETF	125.91	125.99	125.8	125.99	39900.0
2007-01-18 09:00:00	DIA	ETF	126.0	126.08	125.69	125.95	1084100.0
2007-01-18 10:00:00	DIA	ETF	125.95	125.95	125.46	125.6	2625000.0
2007-01-18 11:00:00	DIA	ETF	125.61	125.84	125.6	125.7	1329700.0
2007-01-18 12:00:00	DIA	ETF	125.71	125.9	125.61	125.74	796100.0
2007-01-18 13:00:00	DIA	ETF	125.74	125.78	125.65	125.7	714600.0

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

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