PREVIEW / etf_1hour / 2007-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-13.parquet
  size:    66 KB
  rows:    2,040

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-02-13 06:00:00	SPY	ETF	143.66	143.66	143.66	143.66	25000.0
2007-02-13 07:00:00	SPY	ETF	143.65	143.68	143.62	143.66	31500.0
2007-02-13 08:00:00	SPY	ETF	143.66	143.75	143.5	143.73	911950.0
2007-02-13 09:00:00	SPY	ETF	143.73	144.13	143.67	144.11	7814357.0
2007-02-13 10:00:00	SPY	ETF	144.11	144.19	143.87	143.91	15853021.0
2007-02-13 11:00:00	SPY	ETF	143.92	144.34	143.9	144.23	8453701.0
2007-02-13 12:00:00	SPY	ETF	144.22	144.45	144.2	144.37	5090407.0
2007-02-13 13:00:00	SPY	ETF	144.37	144.48	144.27	144.2985	4305615.0
2007-02-13 14:00:00	SPY	ETF	144.2901	144.4	144.17	144.33	7523633.0
2007-02-13 15:00:00	SPY	ETF	144.33	144.55	144.2	144.51	8893934.0
2007-02-13 16:00:00	SPY	ETF	144.52	144.66	144.34	144.66	1347503.0
2007-02-13 17:00:00	SPY	ETF	144.67	144.67	144.62	144.65	16900.0
2007-02-13 18:00:00	SPY	ETF	144.62	144.65	144.6	144.6	25220.0
2007-02-13 19:00:00	SPY	ETF	144.62	144.65	144.62	144.65	6400.0
2007-02-13 04:00:00	QQQ	ETF	43.77	43.78	43.77	43.78	4100.0
2007-02-13 07:00:00	QQQ	ETF	43.72	43.75	43.72	43.73	45100.0
2007-02-13 08:00:00	QQQ	ETF	43.74	43.8	43.73	43.8	508116.0
2007-02-13 09:00:00	QQQ	ETF	43.8	43.98	43.76	43.97	12374193.0
2007-02-13 10:00:00	QQQ	ETF	43.98	44.0	43.73	43.76	23324300.0
2007-02-13 11:00:00	QQQ	ETF	43.76	43.9	43.76	43.81	11128300.0
2007-02-13 12:00:00	QQQ	ETF	43.81	43.92	43.8	43.86	7529700.0
2007-02-13 13:00:00	QQQ	ETF	43.86	43.93	43.77	43.79	8240900.0
2007-02-13 14:00:00	QQQ	ETF	43.79	43.84	43.71	43.77	12846200.0
2007-02-13 15:00:00	QQQ	ETF	43.77	43.87	43.7	43.85	10480600.0
2007-02-13 16:00:00	QQQ	ETF	43.86	43.99	43.84	43.98	3955912.0
2007-02-13 17:00:00	QQQ	ETF	43.98	44.0	43.9	43.9	665146.0
2007-02-13 18:00:00	QQQ	ETF	43.93	43.95	43.93	43.94	49066.0
2007-02-13 19:00:00	QQQ	ETF	43.96	43.99	43.96	43.96	136868.0
2007-02-13 08:00:00	IWM	ETF	80.15	80.24	80.15	80.2	324663.0
2007-02-13 09:00:00	IWM	ETF	80.2	80.48	79.59	80.4	4303859.0
2007-02-13 10:00:00	IWM	ETF	80.4	80.55	80.1	80.14	7025233.0
2007-02-13 11:00:00	IWM	ETF	80.14	80.48	80.13	80.35	5491190.0
2007-02-13 12:00:00	IWM	ETF	80.35	80.5	80.33	80.48	2986840.0
2007-02-13 13:00:00	IWM	ETF	80.48	80.61	80.41	80.43	3394607.0
2007-02-13 14:00:00	IWM	ETF	80.44	80.54	80.32	80.3576	5632825.0
2007-02-13 15:00:00	IWM	ETF	80.36	80.65	80.22	80.63	9176311.0
2007-02-13 16:00:00	IWM	ETF	80.64	80.69	80.63	80.67	773717.0
2007-02-13 17:00:00	IWM	ETF	80.67	80.68	80.58	80.61	53020.0
2007-02-13 18:00:00	IWM	ETF	80.63	80.63	80.56	80.61	61600.0
2007-02-13 19:00:00	IWM	ETF	80.62	80.62	80.62	80.62	1800.0
2007-02-13 07:00:00	DIA	ETF	125.9	125.95	125.9	125.95	900.0
2007-02-13 08:00:00	DIA	ETF	125.95	126.01	125.94	126.0	81719.0
2007-02-13 09:00:00	DIA	ETF	125.95	126.36	125.95	126.33	1038371.0
2007-02-13 10:00:00	DIA	ETF	126.33	126.46	126.18	126.21	1156741.0
2007-02-13 11:00:00	DIA	ETF	126.22	127.0	126.15	126.38	1048498.0
2007-02-13 12:00:00	DIA	ETF	126.38	126.63	126.36	126.56	775141.0
2007-02-13 13:00:00	DIA	ETF	126.57	126.65	126.44	126.46	482893.0
2007-02-13 14:00:00	DIA	ETF	126.46	126.54	126.38	126.49	475169.0
2007-02-13 15:00:00	DIA	ETF	126.49	126.65	126.4	126.58	814653.0
2007-02-13 16:00:00	DIA	ETF	126.58	126.66	126.58	126.65	385508.0

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

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