PREVIEW / etf_1hour / 2007-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-26.parquet
  size:    76 KB
  rows:    2,411

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-26 05:00:00	SPY	ETF	143.33	143.33	143.33	143.33	2200.0
2007-03-26 06:00:00	SPY	ETF	143.41	143.41	143.41	143.41	3000.0
2007-03-26 07:00:00	SPY	ETF	143.41	143.55	143.35	143.45	95200.0
2007-03-26 08:00:00	SPY	ETF	143.45	143.46	143.4	143.45	139500.0
2007-03-26 09:00:00	SPY	ETF	143.46	143.53	143.25	143.49	6605901.0
2007-03-26 10:00:00	SPY	ETF	143.48	143.49	142.12	142.5	45713620.0
2007-03-26 11:00:00	SPY	ETF	142.5	142.77	142.09	142.62	13008504.0
2007-03-26 12:00:00	SPY	ETF	142.64	143.02	142.6	142.79	11479563.0
2007-03-26 13:00:00	SPY	ETF	142.78	143.02	142.69	142.96	6682932.0
2007-03-26 14:00:00	SPY	ETF	142.97	143.18	142.96	143.15	9075303.0
2007-03-26 15:00:00	SPY	ETF	143.14	143.65	142.95	143.59	17171108.0
2007-03-26 16:00:00	SPY	ETF	143.57	143.5985	143.0279	143.3	2575300.0
2007-03-26 17:00:00	SPY	ETF	143.29	143.5985	142.62	143.24	69200.0
2007-03-26 18:00:00	SPY	ETF	143.22	143.24	143.19	143.23	23600.0
2007-03-26 19:00:00	SPY	ETF	143.21	143.23	143.2	143.23	2300.0
2007-03-26 07:00:00	QQQ	ETF	44.1	44.22	44.1	44.17	122309.0
2007-03-26 08:00:00	QQQ	ETF	44.15	44.18	44.13	44.18	369019.0
2007-03-26 09:00:00	QQQ	ETF	44.18	44.23	44.09	44.21	6951914.0
2007-03-26 10:00:00	QQQ	ETF	44.2	44.66	43.63	43.83	41985900.0
2007-03-26 11:00:00	QQQ	ETF	43.81	43.96	43.71	43.87	14363100.0
2007-03-26 12:00:00	QQQ	ETF	43.87	44.01	43.85	43.92	6833300.0
2007-03-26 13:00:00	QQQ	ETF	43.92	44.02	43.89	43.98	9322700.0
2007-03-26 14:00:00	QQQ	ETF	43.98	44.13	43.98	44.12	9980300.0
2007-03-26 15:00:00	QQQ	ETF	44.12	44.32	44.09	44.32	14199500.0
2007-03-26 16:00:00	QQQ	ETF	44.31	44.32	44.03	44.25	4664291.0
2007-03-26 17:00:00	QQQ	ETF	44.25	44.317	43.85	44.22	1558072.0
2007-03-26 18:00:00	QQQ	ETF	44.22	44.23	44.22	44.23	9050.0
2007-03-26 19:00:00	QQQ	ETF	44.23	44.24	44.21	44.22	19680.0
2007-03-26 07:00:00	IWM	ETF	80.35	80.35	80.33	80.33	1600.0
2007-03-26 08:00:00	IWM	ETF	80.33	80.33	80.26	80.31	211900.0
2007-03-26 09:00:00	IWM	ETF	80.31	80.48	80.23	80.45	2576100.0
2007-03-26 10:00:00	IWM	ETF	80.45	80.45	79.56	79.78	13460559.0
2007-03-26 11:00:00	IWM	ETF	79.77	79.82	79.48	79.71	7110643.0
2007-03-26 12:00:00	IWM	ETF	79.71	80.02	79.69	79.81	5412099.0
2007-03-26 13:00:00	IWM	ETF	79.81	79.96	79.76	79.855	3630800.0
2007-03-26 14:00:00	IWM	ETF	79.86	80.05	79.86	79.99	3334300.0
2007-03-26 15:00:00	IWM	ETF	80.0	80.25	79.95	80.24	6697827.0
2007-03-26 16:00:00	IWM	ETF	80.23	80.24	79.87	80.02	3393500.0
2007-03-26 17:00:00	IWM	ETF	80.03	80.2385	79.74	80.2385	18300.0
2007-03-26 18:00:00	IWM	ETF	80.02	80.02	80.0	80.0	151100.0
2007-03-26 19:00:00	IWM	ETF	79.98	79.99	79.98	79.99	1800.0
2007-03-26 07:00:00	DIA	ETF	124.75	124.76	124.75	124.76	600.0
2007-03-26 08:00:00	DIA	ETF	124.7	124.72	124.7	124.7	4200.0
2007-03-26 09:00:00	DIA	ETF	124.75	124.79	124.45	124.58	617500.0
2007-03-26 10:00:00	DIA	ETF	124.59	124.59	123.57	123.81	3004204.0
2007-03-26 11:00:00	DIA	ETF	123.81	123.94	123.57	123.85	986100.0
2007-03-26 12:00:00	DIA	ETF	123.84	124.11	123.81	123.95	458089.0
2007-03-26 13:00:00	DIA	ETF	123.95	124.14	123.88	124.1	404600.0
2007-03-26 14:00:00	DIA	ETF	124.1	124.24	124.05	124.2	916800.0
2007-03-26 15:00:00	DIA	ETF	124.2	124.571	124.1325	124.56	1438800.0

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

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