PREVIEW / etf_1hour / 2007-01-30

all etf 1-hour files

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

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-30 07:00:00	SPY	ETF	142.24	142.5	142.22	142.5	495800.0
2007-01-30 08:00:00	SPY	ETF	142.5	142.54	142.05	142.32	1658900.0
2007-01-30 09:00:00	SPY	ETF	142.31	142.41	142.06	142.14	8400300.0
2007-01-30 10:00:00	SPY	ETF	142.14	142.48	142.1	142.31	9339100.0
2007-01-30 11:00:00	SPY	ETF	142.31	142.76	142.26	142.56	15343600.0
2007-01-30 12:00:00	SPY	ETF	142.56	142.63	142.42	142.58	5930100.0
2007-01-30 13:00:00	SPY	ETF	142.59	142.66	142.34	142.61	6148000.0
2007-01-30 14:00:00	SPY	ETF	142.61	142.7	142.44	142.64	11008700.0
2007-01-30 15:00:00	SPY	ETF	142.65	142.83	142.6	142.76	8010700.0
2007-01-30 16:00:00	SPY	ETF	142.75	142.85	141.994	142.83	2357000.0
2007-01-30 17:00:00	SPY	ETF	142.84	142.87	142.75	142.84	201900.0
2007-01-30 18:00:00	SPY	ETF	142.8	142.84	142.8	142.8	3400.0
2007-01-30 19:00:00	SPY	ETF	142.8	142.85	142.77	142.83	12900.0
2007-01-30 07:00:00	QQQ	ETF	43.72	43.8	43.7	43.8	200200.0
2007-01-30 08:00:00	QQQ	ETF	43.8	43.8	43.71	43.71	489238.0
2007-01-30 09:00:00	QQQ	ETF	43.72	43.72	43.53	43.63	9481655.0
2007-01-30 10:00:00	QQQ	ETF	43.63	43.72	43.58	43.65	12121200.0
2007-01-30 11:00:00	QQQ	ETF	43.66	43.79	43.62	43.66	10464600.0
2007-01-30 12:00:00	QQQ	ETF	43.66	43.67	43.56	43.64	7638100.0
2007-01-30 13:00:00	QQQ	ETF	43.64	43.68	43.52	43.65	9652900.0
2007-01-30 14:00:00	QQQ	ETF	43.65	43.66	43.56	43.61	4759800.0
2007-01-30 15:00:00	QQQ	ETF	43.61	43.7	43.59	43.68	9516700.0
2007-01-30 16:00:00	QQQ	ETF	43.68	43.73	43.66	43.71	1649489.0
2007-01-30 17:00:00	QQQ	ETF	43.71	43.74	43.66	43.67	109545.0
2007-01-30 18:00:00	QQQ	ETF	43.69	43.69	43.6	43.68	340615.0
2007-01-30 19:00:00	QQQ	ETF	43.68	43.68	43.66	43.66	29800.0
2007-01-30 07:00:00	IWM	ETF	79.0	79.0	78.95	78.95	10200.0
2007-01-30 08:00:00	IWM	ETF	78.75	79.0	78.75	78.89	443000.0
2007-01-30 09:00:00	IWM	ETF	78.89	78.95	78.51	78.63	2920700.0
2007-01-30 10:00:00	IWM	ETF	78.63	78.96	78.57	78.86	4262800.0
2007-01-30 11:00:00	IWM	ETF	78.87	79.19	78.86	79.05	6385000.0
2007-01-30 12:00:00	IWM	ETF	79.05	79.1599	78.91	79.01	2687300.0
2007-01-30 13:00:00	IWM	ETF	79.01	79.07	78.79	79.04	2498600.0
2007-01-30 14:00:00	IWM	ETF	79.04	79.16	78.95	79.14	3294200.0
2007-01-30 15:00:00	IWM	ETF	79.13	79.26	79.03	79.16	6280700.0
2007-01-30 16:00:00	IWM	ETF	79.15	79.25	79.1	79.2	566200.0
2007-01-30 17:00:00	IWM	ETF	79.17	79.18	79.16	79.18	4000.0
2007-01-30 18:00:00	IWM	ETF	79.18	79.18	79.17	79.17	4500.0
2007-01-30 19:00:00	IWM	ETF	79.2	79.2	79.2	79.2	100.0
2007-01-30 08:00:00	DIA	ETF	125.1	125.1	124.91	124.92	25600.0
2007-01-30 09:00:00	DIA	ETF	124.91	125.2	124.64	124.7	1167600.0
2007-01-30 10:00:00	DIA	ETF	124.71	125.04	124.67	124.88	1392100.0
2007-01-30 11:00:00	DIA	ETF	124.9	125.27	124.85	125.11	1147900.0
2007-01-30 12:00:00	DIA	ETF	125.11	125.15	124.92	125.06	523200.0
2007-01-30 13:00:00	DIA	ETF	125.07	125.12	124.83	125.06	1078700.0
2007-01-30 14:00:00	DIA	ETF	125.06	125.08	124.88	125.05	655600.0
2007-01-30 15:00:00	DIA	ETF	125.06	125.15	124.96	125.13	1095500.0
2007-01-30 16:00:00	DIA	ETF	125.14	125.21	125.14	125.21	31300.0
2007-01-30 17:00:00	DIA	ETF	125.14	125.16	125.14	125.16	300.0
2007-01-30 19:00:00	DIA	ETF	125.16	125.16	125.16	125.16	900.0

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

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