PREVIEW / etf_1hour / 2007-09-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-09-14.parquet
  size:    81 KB
  rows:    2,695

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-09-14 05:00:00	SPY	ETF	148.3	148.3	148.13	148.14	1400.0
2007-09-14 06:00:00	SPY	ETF	148.14	148.28	147.79	147.91	113400.0
2007-09-14 07:00:00	SPY	ETF	147.91	148.35	147.81	148.25	1020100.0
2007-09-14 08:00:00	SPY	ETF	148.11	148.26	147.68	147.88	4202800.0
2007-09-14 09:00:00	SPY	ETF	147.89	148.24	147.74	148.07	14787241.0
2007-09-14 10:00:00	SPY	ETF	148.08	148.85	148.07	148.55	24500300.0
2007-09-14 11:00:00	SPY	ETF	148.56	148.87	148.3	148.725	10866900.0
2007-09-14 12:00:00	SPY	ETF	148.73	148.96	148.5	148.57	7927000.0
2007-09-14 13:00:00	SPY	ETF	148.57	149.06	148.47	149.03	14138300.0
2007-09-14 14:00:00	SPY	ETF	149.03	149.09	148.36	148.56	16650400.0
2007-09-14 15:00:00	SPY	ETF	148.56	149.06	148.51	148.92	18716400.0
2007-09-14 16:00:00	SPY	ETF	148.9	149.04	148.2775	148.91	5487600.0
2007-09-14 17:00:00	SPY	ETF	148.91	148.94	148.88	148.9	141400.0
2007-09-14 18:00:00	SPY	ETF	148.91	148.91	148.82	148.82	6900.0
2007-09-14 19:00:00	SPY	ETF	148.9	148.97	148.9	148.93	4300.0
2007-09-14 05:00:00	QQQ	ETF	48.85	48.85	48.85	48.85	300.0
2007-09-14 06:00:00	QQQ	ETF	48.83	48.83	48.75	48.75	1800.0
2007-09-14 07:00:00	QQQ	ETF	48.73	48.88	48.71	48.85	650599.0
2007-09-14 08:00:00	QQQ	ETF	48.86	48.88	48.73	48.77	2732071.0
2007-09-14 09:00:00	QQQ	ETF	48.78	49.0	48.73	48.962	13580784.0
2007-09-14 10:00:00	QQQ	ETF	48.97	49.24	48.965	49.149	15843263.0
2007-09-14 11:00:00	QQQ	ETF	49.15	49.26	49.06	49.2095	8232207.0
2007-09-14 12:00:00	QQQ	ETF	49.201	49.27	49.08	49.112	6062919.0
2007-09-14 13:00:00	QQQ	ETF	49.11	49.28	49.07	49.28	8848893.0
2007-09-14 14:00:00	QQQ	ETF	49.28	49.31	49.11	49.15	7276944.0
2007-09-14 15:00:00	QQQ	ETF	49.14	49.27	49.11	49.21	10019995.0
2007-09-14 16:00:00	QQQ	ETF	49.21	49.25	48.868	49.22	12858333.0
2007-09-14 17:00:00	QQQ	ETF	49.19	49.21	49.17	49.18	17515.0
2007-09-14 18:00:00	QQQ	ETF	49.21	49.21	49.16	49.17	16979.0
2007-09-14 19:00:00	QQQ	ETF	49.2	49.21	49.16	49.21	9700.0
2007-09-14 06:00:00	IWM	ETF	77.04	77.04	76.97	76.97	1000.0
2007-09-14 07:00:00	IWM	ETF	77.0	77.14	76.91	77.14	34300.0
2007-09-14 08:00:00	IWM	ETF	77.14	77.14	76.75	76.85	617900.0
2007-09-14 09:00:00	IWM	ETF	76.84	77.4	76.75	77.23	7613400.0
2007-09-14 10:00:00	IWM	ETF	77.22	77.71	77.19	77.55	11445200.0
2007-09-14 11:00:00	IWM	ETF	77.54	77.99	77.32	77.85	5180900.0
2007-09-14 12:00:00	IWM	ETF	77.85	78.03	77.66	77.72	4704400.0
2007-09-14 13:00:00	IWM	ETF	77.72	78.02	77.64	77.98	3989000.0
2007-09-14 14:00:00	IWM	ETF	77.98	78.03	77.6	77.72	5041500.0
2007-09-14 15:00:00	IWM	ETF	77.73	78.15	77.66	78.0	8583500.0
2007-09-14 16:00:00	IWM	ETF	78.0	78.28	78.0	78.07	1115600.0
2007-09-14 17:00:00	IWM	ETF	78.07	78.07	78.07	78.07	6500.0
2007-09-14 07:00:00	DIA	ETF	133.7	133.87	133.66	133.87	23100.0
2007-09-14 08:00:00	DIA	ETF	133.86	133.91	133.4	133.56	148600.0
2007-09-14 09:00:00	DIA	ETF	133.55	133.85	133.35	133.76	2001500.0
2007-09-14 10:00:00	DIA	ETF	133.79	134.39	133.79	134.18	2220900.0
2007-09-14 11:00:00	DIA	ETF	134.17	134.41	133.96	134.3	895600.0
2007-09-14 12:00:00	DIA	ETF	134.35	134.47	134.15	134.2	778200.0
2007-09-14 13:00:00	DIA	ETF	134.17	134.56	134.11	134.54	1221200.0
2007-09-14 14:00:00	DIA	ETF	134.53	134.56	134.12	134.25	1155900.0

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

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