PREVIEW / etf_1hour / 2007-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-07-13.parquet
  size:    82 KB
  rows:    2,812

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-07-13 06:00:00	SPY	ETF	154.43	154.43	154.43	154.43	7000.0
2007-07-13 07:00:00	SPY	ETF	154.47	154.75	154.45	154.73	1022000.0
2007-07-13 08:00:00	SPY	ETF	154.75	154.8	154.35	154.56	2901200.0
2007-07-13 09:00:00	SPY	ETF	154.57	154.86	154.39	154.58	15182420.0
2007-07-13 10:00:00	SPY	ETF	154.58	155.21	154.58	155.14	25832926.0
2007-07-13 11:00:00	SPY	ETF	155.14	155.17	154.73	154.76	9019343.0
2007-07-13 12:00:00	SPY	ETF	154.76	154.96	154.72	154.92	7483821.0
2007-07-13 13:00:00	SPY	ETF	154.925	155.1	154.82	155.0	6847200.0
2007-07-13 14:00:00	SPY	ETF	155.01	155.46	154.89	155.39	13440775.0
2007-07-13 15:00:00	SPY	ETF	155.38	155.45	155.1	155.12	19192076.0
2007-07-13 16:00:00	SPY	ETF	155.08	155.18	154.88	154.96	5728500.0
2007-07-13 17:00:00	SPY	ETF	154.96	155.03	154.85	154.9	3021100.0
2007-07-13 18:00:00	SPY	ETF	154.96	154.96	154.83	154.86	17800.0
2007-07-13 19:00:00	SPY	ETF	154.88	154.91	154.87	154.91	400.0
2007-07-13 07:00:00	QQQ	ETF	49.61	49.68	49.61	49.68	225350.0
2007-07-13 08:00:00	QQQ	ETF	49.68	49.71	49.56	49.61	1823220.0
2007-07-13 09:00:00	QQQ	ETF	49.62	49.76	49.57	49.6	13749283.0
2007-07-13 10:00:00	QQQ	ETF	49.6	49.76	49.5699	49.7385	20816144.0
2007-07-13 11:00:00	QQQ	ETF	49.74	49.75	49.62	49.6285	6677807.0
2007-07-13 12:00:00	QQQ	ETF	49.62	49.69	49.61	49.68	3766678.0
2007-07-13 13:00:00	QQQ	ETF	49.678	49.75	49.63	49.7181	3417924.0
2007-07-13 14:00:00	QQQ	ETF	49.72	49.88	49.64	49.86	7560467.0
2007-07-13 15:00:00	QQQ	ETF	49.85	49.97	49.81	49.96	11701937.0
2007-07-13 16:00:00	QQQ	ETF	49.96	49.96	49.86	49.9	1138162.0
2007-07-13 17:00:00	QQQ	ETF	49.7701	49.9	49.64	49.87	218873.0
2007-07-13 18:00:00	QQQ	ETF	49.89	49.91	49.87	49.91	42548.0
2007-07-13 19:00:00	QQQ	ETF	49.92	49.93	49.91	49.93	8300.0
2007-07-13 05:00:00	IWM	ETF	84.88	84.88	84.88	84.88	100.0
2007-07-13 07:00:00	IWM	ETF	84.94	85.01	84.94	85.01	4500.0
2007-07-13 08:00:00	IWM	ETF	85.03	85.03	84.82	84.88	192300.0
2007-07-13 09:00:00	IWM	ETF	84.86	85.07	84.67	84.7	5762828.0
2007-07-13 10:00:00	IWM	ETF	84.71	85.02	84.05	84.98	9721935.0
2007-07-13 11:00:00	IWM	ETF	84.97	84.99	84.73	84.75	2157950.0
2007-07-13 12:00:00	IWM	ETF	84.74	84.9	84.71	84.88	2671473.0
2007-07-13 13:00:00	IWM	ETF	84.89	84.98	84.84	84.94	3181000.0
2007-07-13 14:00:00	IWM	ETF	84.94	85.2	84.9	85.16	3395023.0
2007-07-13 15:00:00	IWM	ETF	85.15	85.2	85.03	85.13	6939001.0
2007-07-13 16:00:00	IWM	ETF	85.12	85.12	84.82	84.89	2746200.0
2007-07-13 18:00:00	IWM	ETF	84.82	84.82	84.82	84.82	800.0
2007-07-13 07:00:00	DIA	ETF	138.44	138.65	138.44	138.65	5700.0
2007-07-13 08:00:00	DIA	ETF	138.64	138.69	138.42	138.5	40000.0
2007-07-13 09:00:00	DIA	ETF	138.54	138.75	138.41	138.56	795700.0
2007-07-13 10:00:00	DIA	ETF	138.57	139.07	138.57	138.98	2154000.0
2007-07-13 11:00:00	DIA	ETF	138.99	139.02	138.78	138.81	740700.0
2007-07-13 12:00:00	DIA	ETF	138.82	138.97	138.76	138.93	475900.0
2007-07-13 13:00:00	DIA	ETF	138.92	139.05	138.84	138.97	433000.0
2007-07-13 14:00:00	DIA	ETF	138.98	139.22	138.85	139.17	986860.0
2007-07-13 15:00:00	DIA	ETF	139.16	139.3	139.03	139.05	1461900.0
2007-07-13 16:00:00	DIA	ETF	139.05	139.05	138.88	138.95	57800.0
2007-07-13 17:00:00	DIA	ETF	138.99	138.99	138.99	138.99	300.0

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

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