PREVIEW / etf_1hour / 2007-03-27

all etf 1-hour files

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

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-27 06:00:00	SPY	ETF	143.1	143.1	143.05	143.05	8300.0
2007-03-27 07:00:00	SPY	ETF	143.1	143.28	143.1	143.27	128900.0
2007-03-27 08:00:00	SPY	ETF	143.27	143.27	143.1	143.13	350700.0
2007-03-27 09:00:00	SPY	ETF	143.13	143.19	142.63	142.83	10129400.0
2007-03-27 10:00:00	SPY	ETF	142.82	143.07	142.5	142.89	23631452.0
2007-03-27 11:00:00	SPY	ETF	142.89	142.92	142.39	142.63	11304436.0
2007-03-27 12:00:00	SPY	ETF	142.63	142.88	142.54	142.8	6623900.0
2007-03-27 13:00:00	SPY	ETF	142.8	142.94	142.72	142.77	8864500.0
2007-03-27 14:00:00	SPY	ETF	142.77	142.85	142.58	142.82	16462457.0
2007-03-27 15:00:00	SPY	ETF	142.82	142.98	142.7	142.71	12921932.0
2007-03-27 16:00:00	SPY	ETF	142.71	143.04	141.86	142.43	5267800.0
2007-03-27 17:00:00	SPY	ETF	142.43	142.74	142.1	142.32	2839500.0
2007-03-27 18:00:00	SPY	ETF	142.35	142.43	142.29	142.34	655600.0
2007-03-27 19:00:00	SPY	ETF	142.33	142.42	142.33	142.42	49900.0
2007-03-27 04:00:00	QQQ	ETF	44.19	44.19	44.19	44.19	300.0
2007-03-27 06:00:00	QQQ	ETF	44.15	44.15	44.14	44.14	400.0
2007-03-27 07:00:00	QQQ	ETF	44.17	44.24	44.17	44.23	116980.0
2007-03-27 08:00:00	QQQ	ETF	44.25	44.25	44.2	44.2	221442.0
2007-03-27 09:00:00	QQQ	ETF	44.21	44.24	44.12	44.12	8665603.0
2007-03-27 10:00:00	QQQ	ETF	44.13	44.18	44.04	44.16	14456400.0
2007-03-27 11:00:00	QQQ	ETF	44.15	44.15	43.95	44.05	13384600.0
2007-03-27 12:00:00	QQQ	ETF	44.05	44.11	44.02	44.09	4503500.0
2007-03-27 13:00:00	QQQ	ETF	44.09	44.15	44.07	44.1	4051600.0
2007-03-27 14:00:00	QQQ	ETF	44.1	44.11	43.98	44.08	8126600.0
2007-03-27 15:00:00	QQQ	ETF	44.08	44.33	43.99	43.99	14502800.0
2007-03-27 16:00:00	QQQ	ETF	43.99	44.1301	43.73	43.92	4045951.0
2007-03-27 17:00:00	QQQ	ETF	43.9	43.91	43.77	43.8	2657995.0
2007-03-27 18:00:00	QQQ	ETF	43.79	43.87	43.79	43.85	646040.0
2007-03-27 19:00:00	QQQ	ETF	43.85	43.87	43.82	43.87	103053.0
2007-03-27 07:00:00	IWM	ETF	80.06	80.06	80.06	80.06	7200.0
2007-03-27 08:00:00	IWM	ETF	79.97	79.99	79.95	79.95	32100.0
2007-03-27 09:00:00	IWM	ETF	79.96	80.07	79.67	79.68	4836100.0
2007-03-27 10:00:00	IWM	ETF	79.67	79.83	79.52	79.7	11618525.0
2007-03-27 11:00:00	IWM	ETF	79.6999	79.7	79.37	79.55	4735100.0
2007-03-27 12:00:00	IWM	ETF	79.56	79.65	79.5	79.55	2146404.0
2007-03-27 13:00:00	IWM	ETF	79.55	79.7	79.51	79.64	2540000.0
2007-03-27 14:00:00	IWM	ETF	79.63	79.65	79.35	79.51	5719110.0
2007-03-27 15:00:00	IWM	ETF	79.51	79.68	79.47	79.67	4928500.0
2007-03-27 16:00:00	IWM	ETF	79.68	79.8815	79.03	79.35	1296100.0
2007-03-27 17:00:00	IWM	ETF	79.44	79.45	79.16	79.4	732700.0
2007-03-27 18:00:00	IWM	ETF	79.29	79.33	79.18	79.31	354100.0
2007-03-27 19:00:00	IWM	ETF	79.33	79.35	79.33	79.35	1600.0
2007-03-27 07:00:00	DIA	ETF	124.24	124.35	124.24	124.35	2100.0
2007-03-27 08:00:00	DIA	ETF	124.31	124.33	124.25	124.3	4300.0
2007-03-27 09:00:00	DIA	ETF	124.3	124.3	123.97	123.99	595900.0
2007-03-27 10:00:00	DIA	ETF	124.0	124.11	123.7	124.02	1933100.0
2007-03-27 11:00:00	DIA	ETF	124.01	124.03	123.66	123.86	1195100.0
2007-03-27 12:00:00	DIA	ETF	123.86	124.01	123.78	123.97	489700.0
2007-03-27 13:00:00	DIA	ETF	123.96	124.03	123.8	123.85	899400.0
2007-03-27 14:00:00	DIA	ETF	123.84	123.95	123.68	123.94	1108200.0

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

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