PREVIEW / etf_1hour / 2009-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-03.parquet
  size:    149 KB
  rows:    4,613

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
2009-12-03 04:00:00	SPY	ETF	111.88	111.97	111.88	111.97	400.0
2009-12-03 05:00:00	SPY	ETF	111.9	111.9	111.89	111.89	600.0
2009-12-03 06:00:00	SPY	ETF	111.63	111.74	111.55	111.6	16900.0
2009-12-03 07:00:00	SPY	ETF	111.6	111.79	111.55	111.73	634891.0
2009-12-03 08:00:00	SPY	ETF	111.71	111.98	111.31	111.55	7234846.0
2009-12-03 09:00:00	SPY	ETF	111.56	112.18	111.44	111.77	22835758.0
2009-12-03 10:00:00	SPY	ETF	111.78	111.78	111.03	111.49	45777909.0
2009-12-03 11:00:00	SPY	ETF	111.49	111.58	111.21	111.375	12723233.0
2009-12-03 12:00:00	SPY	ETF	111.35	111.5	111.28	111.459	9238683.0
2009-12-03 13:00:00	SPY	ETF	111.45	111.56	111.25	111.4975	10187585.0
2009-12-03 14:00:00	SPY	ETF	111.49	111.57	111.15	111.22	12322205.0
2009-12-03 15:00:00	SPY	ETF	111.2117	111.33	110.29	110.43	38205141.0
2009-12-03 16:00:00	SPY	ETF	110.42	112.1595	110.15	110.15	7000271.0
2009-12-03 17:00:00	SPY	ETF	110.17	110.42	110.11	110.19	296161.0
2009-12-03 18:00:00	SPY	ETF	110.2	110.34	110.17	110.33	229715.0
2009-12-03 19:00:00	SPY	ETF	110.3	110.37	110.15	110.2	56808.0
2009-12-03 04:00:00	QQQ	ETF	44.34	44.34	44.34	44.34	200.0
2009-12-03 06:00:00	QQQ	ETF	44.2	44.25	44.2	44.21	42400.0
2009-12-03 07:00:00	QQQ	ETF	44.2	44.25	44.16	44.2	336394.0
2009-12-03 08:00:00	QQQ	ETF	44.2	44.3	44.13	44.18	4037736.0
2009-12-03 09:00:00	QQQ	ETF	44.19	44.5	44.18	44.38	10224327.0
2009-12-03 10:00:00	QQQ	ETF	44.37	44.385	44.13	44.32	19382056.0
2009-12-03 11:00:00	QQQ	ETF	44.32	44.35	44.2	44.244	5327964.0
2009-12-03 12:00:00	QQQ	ETF	44.24	44.3	44.2	44.29	4215523.0
2009-12-03 13:00:00	QQQ	ETF	44.29	44.33	44.2	44.31	3594941.0
2009-12-03 14:00:00	QQQ	ETF	44.31	44.34	44.23	44.26	5696684.0
2009-12-03 15:00:00	QQQ	ETF	44.26	44.3	43.88	43.9	15422258.0
2009-12-03 16:00:00	QQQ	ETF	43.9	44.16	43.76	43.76	2548213.0
2009-12-03 17:00:00	QQQ	ETF	43.77	43.79	43.74	43.79	69922.0
2009-12-03 18:00:00	QQQ	ETF	43.79	43.83	43.79	43.83	21663.0
2009-12-03 19:00:00	QQQ	ETF	43.83	43.83	43.77	43.8	19380.0
2009-12-03 06:00:00	IWM	ETF	60.12	60.12	60.05	60.05	700.0
2009-12-03 07:00:00	IWM	ETF	60.05	60.2	60.0	60.15	27400.0
2009-12-03 08:00:00	IWM	ETF	60.16	60.27	59.99	60.04	1158851.0
2009-12-03 09:00:00	IWM	ETF	60.04	60.37	59.81	60.25	9127341.0
2009-12-03 10:00:00	IWM	ETF	60.26	60.26	59.67	59.91	11651984.0
2009-12-03 11:00:00	IWM	ETF	59.91	60.05	59.87	59.89	3713149.0
2009-12-03 12:00:00	IWM	ETF	59.9	59.965	59.81	59.93	2106567.0
2009-12-03 13:00:00	IWM	ETF	59.9399	60.02	59.85	60.01	2447213.0
2009-12-03 14:00:00	IWM	ETF	60.0	60.05	59.65	59.675	4258937.0
2009-12-03 15:00:00	IWM	ETF	59.67	59.69	58.93	58.97	13535694.0
2009-12-03 16:00:00	IWM	ETF	58.98	59.7319	58.88	58.89	2649604.0
2009-12-03 17:00:00	IWM	ETF	58.89	58.92	58.84	58.89	10102.0
2009-12-03 18:00:00	IWM	ETF	58.88	58.93	58.86	58.93	1800.0
2009-12-03 19:00:00	IWM	ETF	58.87	58.87	58.85	58.85	500.0
2009-12-03 07:00:00	DIA	ETF	104.85	104.85	104.8	104.8	200.0
2009-12-03 08:00:00	DIA	ETF	104.95	105.07	104.78	104.78	205353.0
2009-12-03 09:00:00	DIA	ETF	104.8	105.18	104.7	104.84	1530202.0
2009-12-03 10:00:00	DIA	ETF	104.81	104.81	104.151	104.67	2767753.0
2009-12-03 11:00:00	DIA	ETF	104.66	104.74	104.46	104.5443	591101.0

> showing 50 of 4,613 rows — these rows as CSV

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