PREVIEW / etf_1hour / 2007-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-11.parquet
  size:    61 KB
  rows:    1,912

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-11 06:00:00	SPY	ETF	141.53	141.53	141.53	141.53	17500.0
2007-01-11 07:00:00	SPY	ETF	141.53	141.54	141.3	141.46	317400.0
2007-01-11 08:00:00	SPY	ETF	141.41	141.54	141.17	141.37	1891100.0
2007-01-11 09:00:00	SPY	ETF	141.38	142.11	141.38	142.02	7812400.0
2007-01-11 10:00:00	SPY	ETF	142.02	142.35	141.94	142.34	9517300.0
2007-01-11 11:00:00	SPY	ETF	142.33	142.61	142.33	142.48	7551700.0
2007-01-11 12:00:00	SPY	ETF	142.47	142.62	142.42	142.52	4037500.0
2007-01-11 13:00:00	SPY	ETF	142.52	142.53	142.24	142.25	5487100.0
2007-01-11 14:00:00	SPY	ETF	142.25	142.47	142.01	142.4	7925500.0
2007-01-11 15:00:00	SPY	ETF	142.41	142.5	142.08	142.27	7411200.0
2007-01-11 16:00:00	SPY	ETF	142.26	142.3	142.16	142.18	1783700.0
2007-01-11 17:00:00	SPY	ETF	142.17	142.2	142.17	142.2	13800.0
2007-01-11 18:00:00	SPY	ETF	142.19	142.23	142.19	142.23	1600.0
2007-01-11 06:00:00	QQQ	ETF	44.65	44.74	44.65	44.74	14300.0
2007-01-11 07:00:00	QQQ	ETF	44.74	44.76	44.63	44.71	177174.0
2007-01-11 08:00:00	QQQ	ETF	44.69	44.71	44.6	44.68	2245593.0
2007-01-11 09:00:00	QQQ	ETF	44.68	44.89	44.65	44.83	19879239.0
2007-01-11 10:00:00	QQQ	ETF	44.82	45.0	44.79	44.99	27061100.0
2007-01-11 11:00:00	QQQ	ETF	44.99	45.24	44.97	45.14	38706300.0
2007-01-11 12:00:00	QQQ	ETF	45.14	45.2	45.07	45.2	12835800.0
2007-01-11 13:00:00	QQQ	ETF	45.19	45.2	45.03	45.05	17328900.0
2007-01-11 14:00:00	QQQ	ETF	45.05	45.19	44.95	45.15	13498400.0
2007-01-11 15:00:00	QQQ	ETF	45.16	45.21	44.91	45.07	28815500.0
2007-01-11 16:00:00	QQQ	ETF	45.07	45.12	45.05	45.08	4646358.0
2007-01-11 17:00:00	QQQ	ETF	45.08	45.12	45.07	45.09	80024.0
2007-01-11 18:00:00	QQQ	ETF	45.1	45.12	45.09	45.11	17965.0
2007-01-11 19:00:00	QQQ	ETF	45.1	45.12	45.08	45.08	31588.0
2007-01-11 08:00:00	IWM	ETF	77.4	77.4	76.75	77.35	542500.0
2007-01-11 09:00:00	IWM	ETF	77.4	78.12	77.4	78.02	9947500.0
2007-01-11 10:00:00	IWM	ETF	78.02	78.39	77.94	78.23	8729500.0
2007-01-11 11:00:00	IWM	ETF	78.25	78.54	78.24	78.29	5599200.0
2007-01-11 12:00:00	IWM	ETF	78.28	78.4	78.16	78.3	3072900.0
2007-01-11 13:00:00	IWM	ETF	78.3	78.3	77.97	77.99	6210100.0
2007-01-11 14:00:00	IWM	ETF	77.99	78.16	77.69	78.13	7810200.0
2007-01-11 15:00:00	IWM	ETF	78.14	78.3	77.95	78.24	5056500.0
2007-01-11 16:00:00	IWM	ETF	78.25	78.25	78.18	78.22	427200.0
2007-01-11 17:00:00	IWM	ETF	78.17	78.17	78.16	78.16	10000.0
2007-01-11 08:00:00	DIA	ETF	124.37	124.43	124.2	124.35	17800.0
2007-01-11 09:00:00	DIA	ETF	124.36	124.83	124.36	124.77	665100.0
2007-01-11 10:00:00	DIA	ETF	124.77	125.05	124.69	125.03	912700.0
2007-01-11 11:00:00	DIA	ETF	125.05	125.27	125.02	125.18	1009600.0
2007-01-11 12:00:00	DIA	ETF	125.18	125.35	125.13	125.24	668400.0
2007-01-11 13:00:00	DIA	ETF	125.25	125.26	125.08	125.12	688400.0
2007-01-11 14:00:00	DIA	ETF	125.12	125.28	124.8	125.19	793900.0
2007-01-11 15:00:00	DIA	ETF	125.2	125.31	124.97	125.04	1405300.0
2007-01-11 16:00:00	DIA	ETF	125.04	125.04	124.96	124.99	573900.0
2007-01-11 17:00:00	DIA	ETF	124.99	124.99	124.99	124.99	900.0
2007-01-11 07:00:00	GLD	ETF	60.7	60.86	60.7	60.86	11000.0
2007-01-11 08:00:00	GLD	ETF	60.96	61.09	60.67	60.75	148600.0
2007-01-11 09:00:00	GLD	ETF	60.77	60.83	60.63	60.7	821200.0

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

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