PREVIEW / etf_1hour / 2008-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-18.parquet
  size:    109 KB
  rows:    3,489

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
2008-06-18 04:00:00	SPY	ETF	135.44	135.52	135.44	135.52	200.0
2008-06-18 05:00:00	SPY	ETF	135.66	135.66	135.66	135.66	100.0
2008-06-18 06:00:00	SPY	ETF	135.33	135.33	134.98	135.1	62800.0
2008-06-18 07:00:00	SPY	ETF	135.1	135.1	134.49	134.56	2108382.0
2008-06-18 08:00:00	SPY	ETF	134.57	135.74	134.35	134.68	5365436.0
2008-06-18 09:00:00	SPY	ETF	134.69	135.08	134.51	134.541	25162547.0
2008-06-18 10:00:00	SPY	ETF	134.55	134.79	133.91	134.14	43395466.0
2008-06-18 11:00:00	SPY	ETF	134.14	135.06	134.08	134.829	37983031.0
2008-06-18 12:00:00	SPY	ETF	134.82	135.5235	134.26	134.41	23940171.0
2008-06-18 13:00:00	SPY	ETF	134.4	134.41	133.78	134.14	36039437.0
2008-06-18 14:00:00	SPY	ETF	134.13	134.52	133.71	134.41	37035485.0
2008-06-18 15:00:00	SPY	ETF	134.41	134.9	134.08	134.33	46860889.0
2008-06-18 16:00:00	SPY	ETF	134.35	134.82	134.09	134.09	5672947.0
2008-06-18 17:00:00	SPY	ETF	134.09	134.09	134.01	134.03	191795.0
2008-06-18 18:00:00	SPY	ETF	134.04	135.5235	133.99	134.05	1045279.0
2008-06-18 19:00:00	SPY	ETF	133.99	134.08	133.95	134.08	21068.0
2008-06-18 06:00:00	QQQ	ETF	48.47	48.5	48.47	48.49	1400.0
2008-06-18 07:00:00	QQQ	ETF	48.51	48.51	48.26	48.31	373825.0
2008-06-18 08:00:00	QQQ	ETF	48.33	48.36	48.17	48.3	1624931.0
2008-06-18 09:00:00	QQQ	ETF	48.31	48.37	48.0	48.12	20071787.0
2008-06-18 10:00:00	QQQ	ETF	48.12	48.24	47.83	47.9	28949207.0
2008-06-18 11:00:00	QQQ	ETF	47.9	48.45	47.87	48.37	23140447.0
2008-06-18 12:00:00	QQQ	ETF	48.37	48.381	48.04	48.11	14316342.0
2008-06-18 13:00:00	QQQ	ETF	48.11	48.11	47.88	48.04	17116243.0
2008-06-18 14:00:00	QQQ	ETF	48.04	48.16	47.87	48.09	18102245.0
2008-06-18 15:00:00	QQQ	ETF	48.09	48.33	48.0	48.01	28223554.0
2008-06-18 16:00:00	QQQ	ETF	48.01	48.5527	47.93	47.96	7695089.0
2008-06-18 17:00:00	QQQ	ETF	47.96	47.97	47.9	47.93	217094.0
2008-06-18 18:00:00	QQQ	ETF	47.93	47.93	47.89	47.93	17027.0
2008-06-18 19:00:00	QQQ	ETF	47.93	47.95	47.92	47.93	22100.0
2008-06-18 06:00:00	IWM	ETF	73.66	73.66	73.46	73.46	800.0
2008-06-18 07:00:00	IWM	ETF	73.38	73.44	73.16	73.17	126219.0
2008-06-18 08:00:00	IWM	ETF	73.17	73.35	73.03	73.3	571952.0
2008-06-18 09:00:00	IWM	ETF	73.3	73.49	73.0	73.05	9042159.0
2008-06-18 10:00:00	IWM	ETF	73.06	73.22	72.49	72.6	15081228.0
2008-06-18 11:00:00	IWM	ETF	72.6	73.4	72.58	73.25	10298508.0
2008-06-18 12:00:00	IWM	ETF	73.25	73.28	72.82	72.91	7745025.0
2008-06-18 13:00:00	IWM	ETF	72.9	72.91	72.59	72.74	7942353.0
2008-06-18 14:00:00	IWM	ETF	72.73	73.04	72.52	73.0	9542075.0
2008-06-18 15:00:00	IWM	ETF	73.01	73.35	72.87	73.15	12352808.0
2008-06-18 16:00:00	IWM	ETF	73.15	73.62	72.95	73.62	7363310.0
2008-06-18 17:00:00	IWM	ETF	73.04	73.18	72.95	73.05	2009395.0
2008-06-18 18:00:00	IWM	ETF	73.04	73.04	72.96	72.96	250.0
2008-06-18 19:00:00	IWM	ETF	73.03	73.03	73.03	73.03	200.0
2008-06-18 07:00:00	DIA	ETF	121.57	121.57	121.05	121.12	41606.0
2008-06-18 08:00:00	DIA	ETF	121.11	121.22	120.97	121.17	112480.0
2008-06-18 09:00:00	DIA	ETF	121.15	121.55	121.0	121.04	1879318.0
2008-06-18 10:00:00	DIA	ETF	121.04	121.15	120.39	120.54	3423378.0
2008-06-18 11:00:00	DIA	ETF	120.55	121.32	120.5	121.12	2737137.0
2008-06-18 12:00:00	DIA	ETF	121.11	121.14	120.58	120.72	1284649.0

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

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