PREVIEW / etf_1hour / 2007-03-21

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-21.parquet
  size:    68 KB
  rows:    2,156

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-03-21 06:00:00	SPY	ETF	140.89	140.89	140.89	140.89	2000.0
2007-03-21 07:00:00	SPY	ETF	140.93	141.09	140.9	140.99	411100.0
2007-03-21 08:00:00	SPY	ETF	141.0	141.1	140.76	141.09	1062600.0
2007-03-21 09:00:00	SPY	ETF	141.1	141.26	140.83	140.92	10048550.0
2007-03-21 10:00:00	SPY	ETF	140.91	141.09	140.82	141.04	7559148.0
2007-03-21 11:00:00	SPY	ETF	141.04	141.08	140.92	140.98	3423400.0
2007-03-21 12:00:00	SPY	ETF	140.98	141.17	140.97	141.14	5204100.0
2007-03-21 13:00:00	SPY	ETF	141.15	141.34	141.11	141.25	7395861.0
2007-03-21 14:00:00	SPY	ETF	141.25	143.46	141.14	143.4	63280407.0
2007-03-21 15:00:00	SPY	ETF	143.4	143.65	142.8	143.3226	49625682.0
2007-03-21 16:00:00	SPY	ETF	143.35	143.35	143.04	143.15	2065400.0
2007-03-21 17:00:00	SPY	ETF	143.13	143.19	143.11	143.11	296600.0
2007-03-21 18:00:00	SPY	ETF	143.09	143.36	143.05	143.07	825100.0
2007-03-21 19:00:00	SPY	ETF	143.1	143.11	143.03	143.04	125900.0
2007-03-21 07:00:00	QQQ	ETF	43.62	43.71	43.62	43.67	374668.0
2007-03-21 08:00:00	QQQ	ETF	43.67	43.69	43.64	43.69	1886369.0
2007-03-21 09:00:00	QQQ	ETF	43.68	43.69	43.35	43.41	29390067.0
2007-03-21 10:00:00	QQQ	ETF	43.4	43.47	43.35	43.45	9264400.0
2007-03-21 11:00:00	QQQ	ETF	43.44	43.47	43.4	43.42	3483800.0
2007-03-21 12:00:00	QQQ	ETF	43.42	43.49	43.42	43.48	2671400.0
2007-03-21 13:00:00	QQQ	ETF	43.48	43.56	43.47	43.52	6520100.0
2007-03-21 14:00:00	QQQ	ETF	43.52	44.3	43.46	44.28	66799600.0
2007-03-21 15:00:00	QQQ	ETF	44.28	44.43	43.8	44.43	44199700.0
2007-03-21 16:00:00	QQQ	ETF	44.43	44.43	44.31	44.36	6972657.0
2007-03-21 17:00:00	QQQ	ETF	44.35	44.42	44.34	44.4	447213.0
2007-03-21 18:00:00	QQQ	ETF	44.39	44.46	44.34	44.36	252726.0
2007-03-21 19:00:00	QQQ	ETF	44.37	44.38	44.34	44.34	58768.0
2007-03-21 08:00:00	IWM	ETF	79.0	79.0	78.99	78.99	1400.0
2007-03-21 09:00:00	IWM	ETF	78.97	78.97	78.74	78.8	4140000.0
2007-03-21 10:00:00	IWM	ETF	78.79	79.0	78.73	78.96	8130100.0
2007-03-21 11:00:00	IWM	ETF	78.96	78.99	78.85	78.9	2775400.0
2007-03-21 12:00:00	IWM	ETF	78.9	78.96	78.85	78.95	4624000.0
2007-03-21 13:00:00	IWM	ETF	78.95	79.11	78.88	79.06	4189300.0
2007-03-21 14:00:00	IWM	ETF	79.05	81.12	78.91	80.33	30598200.0
2007-03-21 15:00:00	IWM	ETF	80.33	80.8	79.97	80.27	19742616.0
2007-03-21 16:00:00	IWM	ETF	80.27	80.37	79.5	80.27	2113900.0
2007-03-21 17:00:00	IWM	ETF	80.3	80.32	80.25	80.25	12000.0
2007-03-21 18:00:00	IWM	ETF	78.82	80.26	78.82	80.25	161600.0
2007-03-21 19:00:00	IWM	ETF	80.25	80.25	80.15	80.15	137800.0
2007-03-21 07:00:00	DIA	ETF	122.85	122.85	122.85	122.85	100.0
2007-03-21 08:00:00	DIA	ETF	122.8	122.8	122.76	122.79	1700.0
2007-03-21 09:00:00	DIA	ETF	122.86	122.86	122.55	122.59	440456.0
2007-03-21 10:00:00	DIA	ETF	122.59	122.72	122.51	122.65	930725.0
2007-03-21 11:00:00	DIA	ETF	122.65	122.69	122.55	122.62	340700.0
2007-03-21 12:00:00	DIA	ETF	122.61	122.73	122.58	122.73	236600.0
2007-03-21 13:00:00	DIA	ETF	122.73	122.84	122.69	122.78	356100.0
2007-03-21 14:00:00	DIA	ETF	122.77	124.48	122.32	124.45	4006200.0
2007-03-21 15:00:00	DIA	ETF	124.44	124.74	124.06	124.38	3281000.0
2007-03-21 16:00:00	DIA	ETF	124.39	124.4	124.16	124.23	59500.0
2007-03-21 17:00:00	DIA	ETF	124.23	124.29	124.23	124.29	200.0

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

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