PREVIEW / etf_1hour / 2007-11-27

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-27.parquet
  size:    95 KB
  rows:    3,140

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-11-27 04:00:00	SPY	ETF	142.37	142.71	142.37	142.65	8900.0
2007-11-27 05:00:00	SPY	ETF	142.6	142.6	142.35	142.41	16300.0
2007-11-27 06:00:00	SPY	ETF	142.38	142.4	142.08	142.08	169600.0
2007-11-27 07:00:00	SPY	ETF	142.05	142.21	141.33	141.41	1693300.0
2007-11-27 08:00:00	SPY	ETF	142.05	142.55	141.2	141.92	6437500.0
2007-11-27 09:00:00	SPY	ETF	141.87	142.36	141.46	141.97	29124101.0
2007-11-27 10:00:00	SPY	ETF	141.97	142.82	140.95	142.68	65169930.0
2007-11-27 11:00:00	SPY	ETF	142.68	143.08	142.24	142.51	28497218.0
2007-11-27 12:00:00	SPY	ETF	142.52	143.1	142.08	142.74	27844906.0
2007-11-27 13:00:00	SPY	ETF	142.74	143.05	142.17	142.33	22514310.0
2007-11-27 14:00:00	SPY	ETF	142.34	142.49	141.16	141.72	36819619.0
2007-11-27 15:00:00	SPY	ETF	141.72	143.23	141.43	143.09	46305418.0
2007-11-27 16:00:00	SPY	ETF	143.06	143.08	141.4894	142.53	20337900.0
2007-11-27 17:00:00	SPY	ETF	142.53	142.62	142.44	142.5	5926700.0
2007-11-27 18:00:00	SPY	ETF	142.5	142.7	142.5	142.65	112000.0
2007-11-27 19:00:00	SPY	ETF	142.69	142.79	142.5	142.53	46600.0
2007-11-27 04:00:00	QQQ	ETF	49.52	49.53	49.52	49.53	900.0
2007-11-27 05:00:00	QQQ	ETF	49.46	49.5	49.46	49.5	22700.0
2007-11-27 06:00:00	QQQ	ETF	49.42	49.45	49.39	49.44	81000.0
2007-11-27 07:00:00	QQQ	ETF	49.36	49.4	49.25	49.27	215518.0
2007-11-27 08:00:00	QQQ	ETF	49.27	49.53	49.19	49.39	1266994.0
2007-11-27 09:00:00	QQQ	ETF	49.41	49.73	49.29	49.57	25294094.0
2007-11-27 10:00:00	QQQ	ETF	49.57	50.0	49.1	49.96	41572832.0
2007-11-27 11:00:00	QQQ	ETF	49.97	50.05	49.75	49.78	21432451.0
2007-11-27 12:00:00	QQQ	ETF	49.78	50.04	49.69	49.8305	15754457.0
2007-11-27 13:00:00	QQQ	ETF	49.84	49.95	49.6	49.66	20267672.0
2007-11-27 14:00:00	QQQ	ETF	49.66	50.0	49.26	49.4701	29260721.0
2007-11-27 15:00:00	QQQ	ETF	49.4701	50.05	49.34	50.02	48418850.0
2007-11-27 16:00:00	QQQ	ETF	50.01	50.02	49.82	49.85	7778288.0
2007-11-27 17:00:00	QQQ	ETF	49.85	49.88	49.8	49.84	74656.0
2007-11-27 18:00:00	QQQ	ETF	49.84	49.92	49.84	49.92	70810.0
2007-11-27 19:00:00	QQQ	ETF	49.91	49.94	49.87	49.87	7350.0
2007-11-27 05:00:00	IWM	ETF	73.75	73.75	73.75	73.75	5000.0
2007-11-27 07:00:00	IWM	ETF	73.68	73.72	73.2	73.25	206700.0
2007-11-27 08:00:00	IWM	ETF	73.25	73.55	73.18	73.5	841000.0
2007-11-27 09:00:00	IWM	ETF	73.44	74.08	73.41	73.84	11742196.0
2007-11-27 10:00:00	IWM	ETF	73.84	74.16	73.16	74.12	16704700.0
2007-11-27 11:00:00	IWM	ETF	74.13	74.4	73.89	74.01	8827399.0
2007-11-27 12:00:00	IWM	ETF	74.03	74.32	73.73	74.14	7389600.0
2007-11-27 13:00:00	IWM	ETF	74.14	74.34	73.74	73.83	5907000.0
2007-11-27 14:00:00	IWM	ETF	73.82	73.96	73.29	73.64	10295655.0
2007-11-27 15:00:00	IWM	ETF	73.62	74.27	73.37	74.14	15952117.0
2007-11-27 16:00:00	IWM	ETF	74.14	74.26	73.27	73.99	3800900.0
2007-11-27 17:00:00	IWM	ETF	73.95	73.97	73.8	73.8	108200.0
2007-11-27 18:00:00	IWM	ETF	73.81	73.81	73.81	73.81	3900.0
2007-11-27 19:00:00	IWM	ETF	74.1	74.1	74.1	74.1	500.0
2007-11-27 05:00:00	DIA	ETF	128.12	128.12	128.12	128.12	300.0
2007-11-27 07:00:00	DIA	ETF	128.15	128.15	127.76	127.76	11900.0
2007-11-27 08:00:00	DIA	ETF	127.72	128.09	127.49	128.05	269000.0
2007-11-27 09:00:00	DIA	ETF	128.01	128.59	127.88	128.42	2169687.0

> showing 50 of 3,140 rows — these rows as CSV

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