PREVIEW / etf_1hour / 2007-03-28

all etf 1-hour files

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

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-28 05:00:00	SPY	ETF	142.49	142.49	142.49	142.49	100.0
2007-03-28 06:00:00	SPY	ETF	142.51	142.54	142.4	142.4	43500.0
2007-03-28 07:00:00	SPY	ETF	142.43	142.45	142.14	142.27	850000.0
2007-03-28 08:00:00	SPY	ETF	142.28	142.46	141.95	142.17	2744000.0
2007-03-28 09:00:00	SPY	ETF	142.17	142.33	142.02	142.1	16109718.0
2007-03-28 10:00:00	SPY	ETF	142.1	142.28	141.26	141.8	36785474.0
2007-03-28 11:00:00	SPY	ETF	141.8	142.37	141.48	141.71	16022356.0
2007-03-28 12:00:00	SPY	ETF	141.7	142.47	141.69	142.19	21598781.0
2007-03-28 13:00:00	SPY	ETF	142.1915	142.35	141.95	142.06	9775600.0
2007-03-28 14:00:00	SPY	ETF	142.06	142.19	141.5	141.68	21592200.0
2007-03-28 15:00:00	SPY	ETF	141.68	142.04	141.53	141.54	21475708.0
2007-03-28 16:00:00	SPY	ETF	141.55	142.5	141.51	141.8	4570500.0
2007-03-28 17:00:00	SPY	ETF	141.81	141.85	141.74	141.76	48600.0
2007-03-28 18:00:00	SPY	ETF	141.79	141.86	141.76	141.86	49800.0
2007-03-28 19:00:00	SPY	ETF	141.82	141.84	141.81	141.84	12100.0
2007-03-28 07:00:00	QQQ	ETF	43.86	43.89	43.76	43.84	600712.0
2007-03-28 08:00:00	QQQ	ETF	43.82	43.84	43.7	43.79	4190026.0
2007-03-28 09:00:00	QQQ	ETF	43.78	43.91	43.74	43.82	13119589.0
2007-03-28 10:00:00	QQQ	ETF	43.82	44.63	43.55	43.75	31897200.0
2007-03-28 11:00:00	QQQ	ETF	43.76	43.81	43.62	43.68	13192000.0
2007-03-28 12:00:00	QQQ	ETF	43.69	44.03	43.68	43.92	23641400.0
2007-03-28 13:00:00	QQQ	ETF	43.92	43.95	43.8	43.82	7640400.0
2007-03-28 14:00:00	QQQ	ETF	43.83	43.87	43.58	43.67	20994900.0
2007-03-28 15:00:00	QQQ	ETF	43.67	43.78	43.51	43.52	20713400.0
2007-03-28 16:00:00	QQQ	ETF	43.51	43.57	43.5	43.55	5007579.0
2007-03-28 17:00:00	QQQ	ETF	43.54	43.57	43.51	43.51	1792967.0
2007-03-28 18:00:00	QQQ	ETF	43.54	43.6	43.53	43.6	77002.0
2007-03-28 19:00:00	QQQ	ETF	43.59	43.6	43.57	43.6	4850.0
2007-03-28 07:00:00	IWM	ETF	79.29	79.29	79.2	79.2	94200.0
2007-03-28 08:00:00	IWM	ETF	79.18	79.36	79.13	79.21	1777100.0
2007-03-28 09:00:00	IWM	ETF	79.2	79.3	79.11	79.17	7467316.0
2007-03-28 10:00:00	IWM	ETF	79.17	79.35	78.61	79.01	21020980.0
2007-03-28 11:00:00	IWM	ETF	79.03	79.21	78.83	79.04	9015150.0
2007-03-28 12:00:00	IWM	ETF	79.04	79.5	79.03	79.41	7865000.0
2007-03-28 13:00:00	IWM	ETF	79.41	79.45	79.24	79.29	2455100.0
2007-03-28 14:00:00	IWM	ETF	79.29	79.38	78.9	79.1	5519800.0
2007-03-28 15:00:00	IWM	ETF	79.1	79.29	78.99	79.05	9558800.0
2007-03-28 16:00:00	IWM	ETF	79.05	79.3	79.02	79.19	382300.0
2007-03-28 17:00:00	IWM	ETF	79.18	79.22	79.18	79.22	10700.0
2007-03-28 18:00:00	IWM	ETF	79.18	79.23	79.15	79.19	18400.0
2007-03-28 19:00:00	IWM	ETF	79.19	79.24	79.19	79.24	2800.0
2007-03-28 07:00:00	DIA	ETF	123.57	123.57	123.44	123.55	8000.0
2007-03-28 08:00:00	DIA	ETF	123.45	123.66	123.37	123.49	772500.0
2007-03-28 09:00:00	DIA	ETF	123.48	123.61	123.16	123.19	3249300.0
2007-03-28 10:00:00	DIA	ETF	123.18	123.31	122.45	122.84	2417950.0
2007-03-28 11:00:00	DIA	ETF	122.84	123.03	122.613	122.81	1207674.0
2007-03-28 12:00:00	DIA	ETF	122.81	123.42	122.81	123.2315	1021800.0
2007-03-28 13:00:00	DIA	ETF	123.2499	123.41	123.06	123.2	2525300.0
2007-03-28 14:00:00	DIA	ETF	123.2	123.3	122.76	122.88	1049800.0
2007-03-28 15:00:00	DIA	ETF	122.88	123.18	122.78	122.81	1508400.0

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

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