PREVIEW / etf_1hour / 2007-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-21.parquet
  size:    93 KB
  rows:    3,109

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-21 04:00:00	SPY	ETF	143.44	143.44	143.44	143.44	500.0
2007-11-21 05:00:00	SPY	ETF	142.98	143.01	142.61	142.88	31400.0
2007-11-21 06:00:00	SPY	ETF	142.88	143.09	142.84	143.08	169100.0
2007-11-21 07:00:00	SPY	ETF	143.13	143.33	142.68	142.76	1511100.0
2007-11-21 08:00:00	SPY	ETF	142.77	143.25	142.6	143.15	9745600.0
2007-11-21 09:00:00	SPY	ETF	143.14	143.38	142.56	143.08	30987799.0
2007-11-21 10:00:00	SPY	ETF	143.08	143.23	141.88	142.12	43347026.0
2007-11-21 11:00:00	SPY	ETF	142.11	143.07	141.74	142.55	44543729.0
2007-11-21 12:00:00	SPY	ETF	142.56	143.55	142.29	143.4	27151763.0
2007-11-21 13:00:00	SPY	ETF	143.4	143.78	142.51	142.9	26459325.0
2007-11-21 14:00:00	SPY	ETF	142.9	143.71	142.77	143.71	16067088.0
2007-11-21 15:00:00	SPY	ETF	143.7	143.91	141.76	141.81	44532079.0
2007-11-21 16:00:00	SPY	ETF	141.83	144.1972	141.67	141.82	8596600.0
2007-11-21 17:00:00	SPY	ETF	141.8	141.88	141.75	141.82	86100.0
2007-11-21 18:00:00	SPY	ETF	141.83	142.0	141.76	141.99	133600.0
2007-11-21 19:00:00	SPY	ETF	141.9	142.15	141.88	141.93	38400.0
2007-11-21 04:00:00	QQQ	ETF	49.55	49.55	49.42	49.44	2900.0
2007-11-21 05:00:00	QQQ	ETF	49.45	49.46	49.45	49.46	25200.0
2007-11-21 06:00:00	QQQ	ETF	49.4	49.5	49.4	49.43	67964.0
2007-11-21 07:00:00	QQQ	ETF	49.47	49.53	49.33	49.35	1431385.0
2007-11-21 08:00:00	QQQ	ETF	49.35	49.5	49.33	49.4	3844404.0
2007-11-21 09:00:00	QQQ	ETF	49.41	49.62	49.34	49.58	25308603.0
2007-11-21 10:00:00	QQQ	ETF	49.58	49.66	48.94	49.05	41781669.0
2007-11-21 11:00:00	QQQ	ETF	49.05	49.87	48.85	49.23	23813480.0
2007-11-21 12:00:00	QQQ	ETF	49.23	49.76	49.18	49.69	22508340.0
2007-11-21 13:00:00	QQQ	ETF	49.69	49.85	49.48	49.66	22656799.0
2007-11-21 14:00:00	QQQ	ETF	49.66	50.07	49.62	50.05	24641431.0
2007-11-21 15:00:00	QQQ	ETF	50.06	50.17	49.0	49.32	42619544.0
2007-11-21 16:00:00	QQQ	ETF	49.33	50.0694	49.16	49.23	4070330.0
2007-11-21 17:00:00	QQQ	ETF	49.23	49.31	49.2	49.23	152430.0
2007-11-21 18:00:00	QQQ	ETF	49.23	49.28	49.21	49.24	297589.0
2007-11-21 19:00:00	QQQ	ETF	49.24	49.27	49.19	49.2	202084.0
2007-11-21 04:00:00	IWM	ETF	74.1	74.1	74.1	74.1	1000.0
2007-11-21 05:00:00	IWM	ETF	74.01	74.04	74.01	74.04	600.0
2007-11-21 06:00:00	IWM	ETF	74.33	74.33	74.33	74.33	10000.0
2007-11-21 07:00:00	IWM	ETF	74.36	74.36	74.11	74.11	148200.0
2007-11-21 08:00:00	IWM	ETF	74.14	74.38	74.01	74.37	253000.0
2007-11-21 09:00:00	IWM	ETF	74.31	74.57	73.84	74.17	8628943.0
2007-11-21 10:00:00	IWM	ETF	74.19	74.31	73.4	73.5	19321667.0
2007-11-21 11:00:00	IWM	ETF	73.49	74.13	73.3	74.07	12465773.0
2007-11-21 12:00:00	IWM	ETF	74.07	74.7	73.87	74.62	10938771.0
2007-11-21 13:00:00	IWM	ETF	74.63	74.7	74.05	74.29	13767616.0
2007-11-21 14:00:00	IWM	ETF	74.29	74.58	74.16	74.57	9603897.0
2007-11-21 15:00:00	IWM	ETF	74.57	74.68	71.1	73.65	16592500.0
2007-11-21 16:00:00	IWM	ETF	73.65	73.78	73.45	73.57	5510900.0
2007-11-21 17:00:00	IWM	ETF	73.49	73.58	73.49	73.57	5600.0
2007-11-21 18:00:00	IWM	ETF	73.57	73.61	73.57	73.61	13100.0
2007-11-21 19:00:00	IWM	ETF	73.6	73.6	73.6	73.6	500.0
2007-11-21 07:00:00	DIA	ETF	129.28	129.28	128.91	128.91	22400.0
2007-11-21 08:00:00	DIA	ETF	128.95	129.21	128.9	129.16	43800.0

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

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