PREVIEW / etf_1hour / 2009-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-04.parquet
  size:    139 KB
  rows:    4,289

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-05-04 04:00:00	SPY	ETF	88.64	88.66	88.51	88.57	9300.0
2009-05-04 05:00:00	SPY	ETF	88.74	88.8	88.73	88.73	42030.0
2009-05-04 06:00:00	SPY	ETF	88.73	88.73	88.49	88.49	30778.0
2009-05-04 07:00:00	SPY	ETF	88.49	88.55	88.26	88.48	482194.0
2009-05-04 08:00:00	SPY	ETF	88.48	88.93	88.25	88.5	3641627.0
2009-05-04 09:00:00	SPY	ETF	88.51	89.18	88.38	89.14	32821440.0
2009-05-04 10:00:00	SPY	ETF	89.14	89.9	89.13	89.61	43834328.0
2009-05-04 11:00:00	SPY	ETF	89.62	90.06	89.57	89.67	28946298.0
2009-05-04 12:00:00	SPY	ETF	89.6799	89.95	89.35	89.65	27978505.0
2009-05-04 13:00:00	SPY	ETF	89.65	90.12	89.6	90.0294	21618407.0
2009-05-04 14:00:00	SPY	ETF	90.0294	90.25	88.6256	90.06	37057106.0
2009-05-04 15:00:00	SPY	ETF	90.06	90.93	89.62	90.93	64064009.0
2009-05-04 16:00:00	SPY	ETF	90.9	90.97	89.3918	90.78	19301990.0
2009-05-04 17:00:00	SPY	ETF	90.77	90.83	90.71	90.81	251689.0
2009-05-04 18:00:00	SPY	ETF	90.8	90.82	90.73	90.82	468616.0
2009-05-04 19:00:00	SPY	ETF	90.82	90.86	90.7	90.73	114590.0
2009-05-04 04:00:00	QQQ	ETF	34.71	34.71	34.71	34.71	1000.0
2009-05-04 05:00:00	QQQ	ETF	34.71	34.79	34.7	34.7	91230.0
2009-05-04 06:00:00	QQQ	ETF	34.7	34.7	34.63	34.63	50870.0
2009-05-04 07:00:00	QQQ	ETF	34.63	34.75	34.59	34.68	676520.0
2009-05-04 08:00:00	QQQ	ETF	34.64	34.7	34.58	34.67	1420508.0
2009-05-04 09:00:00	QQQ	ETF	34.67	34.74	34.52	34.67	14890677.0
2009-05-04 10:00:00	QQQ	ETF	34.67	35.02	34.625	34.8499	21739047.0
2009-05-04 11:00:00	QQQ	ETF	34.85	34.99	34.82	34.855	12396835.0
2009-05-04 12:00:00	QQQ	ETF	34.868	34.97	34.77	34.88	12822212.0
2009-05-04 13:00:00	QQQ	ETF	34.87	35.04	34.84	34.98	11441562.0
2009-05-04 14:00:00	QQQ	ETF	34.99	35.03	34.87	34.91	12759295.0
2009-05-04 15:00:00	QQQ	ETF	34.92	35.09	34.89	35.08	22300698.0
2009-05-04 16:00:00	QQQ	ETF	35.08	35.11	34.87	35.09	4833901.0
2009-05-04 17:00:00	QQQ	ETF	35.1	35.13	35.08	35.12	112380.0
2009-05-04 18:00:00	QQQ	ETF	35.11	35.14	35.1	35.13	177691.0
2009-05-04 19:00:00	QQQ	ETF	35.12	35.14	35.1	35.14	191610.0
2009-05-04 07:00:00	IWM	ETF	49.17	49.21	49.07	49.21	74797.0
2009-05-04 08:00:00	IWM	ETF	49.2	49.55	49.08	49.26	601200.0
2009-05-04 09:00:00	IWM	ETF	49.28	49.55	49.07	49.54	6202492.0
2009-05-04 10:00:00	IWM	ETF	49.54	50.08	49.49	49.79	6046294.0
2009-05-04 11:00:00	IWM	ETF	49.8	50.1	49.7	49.77	3947355.0
2009-05-04 12:00:00	IWM	ETF	49.78	49.96	49.55	49.7	5291999.0
2009-05-04 13:00:00	IWM	ETF	49.7	50.0	49.67	49.94	3195717.0
2009-05-04 14:00:00	IWM	ETF	49.94	50.08	49.82	49.92	4976224.0
2009-05-04 15:00:00	IWM	ETF	49.92	50.7	49.92	50.67	13139301.0
2009-05-04 16:00:00	IWM	ETF	50.67	50.7	50.1	50.55	2506990.0
2009-05-04 17:00:00	IWM	ETF	50.52	50.6	50.45	50.52	72990.0
2009-05-04 18:00:00	IWM	ETF	50.55	50.62	50.5	50.5	4800.0
2009-05-04 19:00:00	IWM	ETF	50.5	50.53	50.5	50.53	500.0
2009-05-04 06:00:00	DIA	ETF	82.88	82.88	82.7	82.7	11462.0
2009-05-04 07:00:00	DIA	ETF	82.7	82.71	82.55	82.71	3100.0
2009-05-04 08:00:00	DIA	ETF	82.7	82.79	82.5	82.69	27225.0
2009-05-04 09:00:00	DIA	ETF	82.73	83.35	82.6	83.35	1545277.0
2009-05-04 10:00:00	DIA	ETF	83.31	83.94	83.31	83.79	2394507.0

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

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