PREVIEW / etf_1hour / 2007-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-08.parquet
  size:    81 KB
  rows:    2,693

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-06-08 04:00:00	SPY	ETF	149.65	149.67	149.51	149.6	17900.0
2007-06-08 05:00:00	SPY	ETF	149.6	149.63	148.69	148.73	11100.0
2007-06-08 06:00:00	SPY	ETF	148.62	148.91	148.33	148.86	80700.0
2007-06-08 07:00:00	SPY	ETF	148.81	149.3	148.5	149.1	2201700.0
2007-06-08 08:00:00	SPY	ETF	148.72	149.55	148.56	149.12	7548600.0
2007-06-08 09:00:00	SPY	ETF	149.1	149.99	149.06	149.85	36607639.0
2007-06-08 10:00:00	SPY	ETF	149.85	150.05	149.35	149.78	30602602.0
2007-06-08 11:00:00	SPY	ETF	149.78	150.1	149.36	149.95	17710376.0
2007-06-08 12:00:00	SPY	ETF	149.95	149.97	149.57	149.86	9010392.0
2007-06-08 13:00:00	SPY	ETF	149.86	150.41	149.69	150.22	17857025.0
2007-06-08 14:00:00	SPY	ETF	150.22	150.72	150.2	150.56	23589060.0
2007-06-08 15:00:00	SPY	ETF	150.56	151.19	150.56	151.05	25393117.0
2007-06-08 16:00:00	SPY	ETF	151.04	151.12	150.87	151.02	2752700.0
2007-06-08 17:00:00	SPY	ETF	151.05	151.21	150.98	151.15	1126200.0
2007-06-08 18:00:00	SPY	ETF	151.16	151.16	151.14	151.15	17500.0
2007-06-08 19:00:00	SPY	ETF	151.15	151.15	151.1	151.14	6800.0
2007-06-08 04:00:00	QQQ	ETF	46.45	46.45	46.43	46.43	10000.0
2007-06-08 05:00:00	QQQ	ETF	46.34	46.34	46.34	46.34	100.0
2007-06-08 06:00:00	QQQ	ETF	46.12	46.24	46.09	46.24	10600.0
2007-06-08 07:00:00	QQQ	ETF	46.2	46.33	46.08	46.26	1427908.0
2007-06-08 08:00:00	QQQ	ETF	46.27	46.43	46.13	46.23	2474103.0
2007-06-08 09:00:00	QQQ	ETF	46.24	46.54	46.16	46.51	26282209.0
2007-06-08 10:00:00	QQQ	ETF	46.51	46.68	46.4	46.56	38170190.0
2007-06-08 11:00:00	QQQ	ETF	46.57	46.63	46.43	46.61	14736580.0
2007-06-08 12:00:00	QQQ	ETF	46.61	46.62	46.5	46.61	22238982.0
2007-06-08 13:00:00	QQQ	ETF	46.6099	46.83	46.55	46.76	17977356.0
2007-06-08 14:00:00	QQQ	ETF	46.76	46.9	46.73	46.79	13614775.0
2007-06-08 15:00:00	QQQ	ETF	46.79	46.93	46.77	46.9	30937254.0
2007-06-08 16:00:00	QQQ	ETF	46.9	46.94	46.88	46.89	2450417.0
2007-06-08 17:00:00	QQQ	ETF	46.89	46.93	46.89	46.9	435726.0
2007-06-08 18:00:00	QQQ	ETF	46.93	46.93	46.92	46.92	15432.0
2007-06-08 19:00:00	QQQ	ETF	46.92	46.94	46.92	46.94	6600.0
2007-06-08 07:00:00	IWM	ETF	81.61	81.74	81.52	81.7	34000.0
2007-06-08 08:00:00	IWM	ETF	81.65	81.86	81.42	81.63	1699500.0
2007-06-08 09:00:00	IWM	ETF	81.61	82.28	81.61	82.18	17450200.0
2007-06-08 10:00:00	IWM	ETF	82.18	82.53	81.84	82.39	17854262.0
2007-06-08 11:00:00	IWM	ETF	82.4	82.44	82.12	82.35	8631200.0
2007-06-08 12:00:00	IWM	ETF	82.35	82.43	82.13	82.24	4736347.0
2007-06-08 13:00:00	IWM	ETF	82.24	82.64	82.16	82.5	5729034.0
2007-06-08 14:00:00	IWM	ETF	82.48	83.02	82.48	82.76	11720250.0
2007-06-08 15:00:00	IWM	ETF	82.76	83.14	82.74	82.97	12606914.0
2007-06-08 16:00:00	IWM	ETF	82.97	83.01	82.75	82.8	1341200.0
2007-06-08 17:00:00	IWM	ETF	82.8	82.8	82.8	82.8	141700.0
2007-06-08 18:00:00	IWM	ETF	82.85	82.85	82.85	82.85	1000.0
2007-06-08 07:00:00	DIA	ETF	132.29	132.7	132.13	132.7	36600.0
2007-06-08 08:00:00	DIA	ETF	132.57	132.87	132.25	132.6	117600.0
2007-06-08 09:00:00	DIA	ETF	132.6	133.22	132.53	133.0	2497450.0
2007-06-08 10:00:00	DIA	ETF	133.02	133.28	132.75	132.84	4091751.0
2007-06-08 11:00:00	DIA	ETF	132.84	133.04	131.75	132.97	2854800.0
2007-06-08 12:00:00	DIA	ETF	132.96	132.98	132.7	132.97	1040100.0

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

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