PREVIEW / etf_1hour / 2008-04-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-09.parquet
  size:    98 KB
  rows:    3,297

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-04-09 04:00:00	SPY	ETF	136.32	136.32	136.32	136.32	200.0
2008-04-09 05:00:00	SPY	ETF	136.18	136.18	136.17	136.17	1100.0
2008-04-09 06:00:00	SPY	ETF	136.17	136.62	136.12	136.54	55500.0
2008-04-09 07:00:00	SPY	ETF	136.74	136.97	136.45	136.62	837400.0
2008-04-09 08:00:00	SPY	ETF	136.62	136.94	136.2	136.57	2686986.0
2008-04-09 09:00:00	SPY	ETF	136.56	136.8	136.06	136.18	21850335.0
2008-04-09 10:00:00	SPY	ETF	136.18	136.28	135.83	136.15	29291690.0
2008-04-09 11:00:00	SPY	ETF	136.15	136.31	135.26	135.319	35451913.0
2008-04-09 12:00:00	SPY	ETF	135.32	135.58	135.14	135.19	16895085.0
2008-04-09 13:00:00	SPY	ETF	135.18	135.59	135.01	135.59	20101120.0
2008-04-09 14:00:00	SPY	ETF	135.59	135.7	134.97	135.06	23168252.0
2008-04-09 15:00:00	SPY	ETF	135.06	135.6	134.89	135.39	29569821.0
2008-04-09 16:00:00	SPY	ETF	135.41	136.47	135.3277	135.83	11561500.0
2008-04-09 17:00:00	SPY	ETF	135.73	135.8	135.67	135.7	100800.0
2008-04-09 18:00:00	SPY	ETF	135.71	135.77	135.63	135.63	63200.0
2008-04-09 19:00:00	SPY	ETF	135.72	135.75	135.6	135.73	45600.0
2008-04-09 05:00:00	QQQ	ETF	45.38	45.38	45.34	45.36	4300.0
2008-04-09 06:00:00	QQQ	ETF	45.31	45.44	45.31	45.44	23000.0
2008-04-09 07:00:00	QQQ	ETF	45.51	45.63	45.49	45.5	396042.0
2008-04-09 08:00:00	QQQ	ETF	45.5	45.54	45.45	45.52	1130367.0
2008-04-09 09:00:00	QQQ	ETF	45.52	45.53	45.0595	45.14	13748040.0
2008-04-09 10:00:00	QQQ	ETF	45.15	45.28	44.98	45.13	21606212.0
2008-04-09 11:00:00	QQQ	ETF	45.13	45.17	44.74	44.79	18991109.0
2008-04-09 12:00:00	QQQ	ETF	44.79	44.9	44.75	44.7619	10442222.0
2008-04-09 13:00:00	QQQ	ETF	44.76	44.96	44.75	44.94	12309167.0
2008-04-09 14:00:00	QQQ	ETF	44.95	45.0	44.63	44.68	15175100.0
2008-04-09 15:00:00	QQQ	ETF	44.6899	44.98	44.64	44.89	20080932.0
2008-04-09 16:00:00	QQQ	ETF	44.89	45.12	44.7825	45.01	6334798.0
2008-04-09 17:00:00	QQQ	ETF	45.01	45.04	44.99	45.03	77544.0
2008-04-09 18:00:00	QQQ	ETF	45.01	45.03	44.96	44.96	29637.0
2008-04-09 19:00:00	QQQ	ETF	45.0	45.01	44.95	45.0	33420.0
2008-04-09 06:00:00	IWM	ETF	71.09	71.09	71.09	71.09	200.0
2008-04-09 07:00:00	IWM	ETF	71.2	71.2	71.1	71.16	21900.0
2008-04-09 08:00:00	IWM	ETF	71.14	71.23	71.04	71.11	194000.0
2008-04-09 09:00:00	IWM	ETF	71.1	71.35	70.8	70.85	5125464.0
2008-04-09 10:00:00	IWM	ETF	70.84	70.91	70.58	70.88	7454479.0
2008-04-09 11:00:00	IWM	ETF	70.88	70.94	69.98	70.01	10421935.0
2008-04-09 12:00:00	IWM	ETF	70.01	70.15	69.85	69.88	7600371.0
2008-04-09 13:00:00	IWM	ETF	69.87	70.12	69.85	70.12	6091619.0
2008-04-09 14:00:00	IWM	ETF	70.12	70.19	69.46	69.54	10291148.0
2008-04-09 15:00:00	IWM	ETF	69.55	69.85	69.45	69.71	14564406.0
2008-04-09 16:00:00	IWM	ETF	69.72	70.98	69.62	69.86	6527900.0
2008-04-09 17:00:00	IWM	ETF	69.82	69.89	69.82	69.89	2800.0
2008-04-09 18:00:00	IWM	ETF	69.8	69.8	69.76	69.76	2600.0
2008-04-09 19:00:00	IWM	ETF	69.77	69.77	69.77	69.77	1000.0
2008-04-09 07:00:00	DIA	ETF	125.95	125.95	125.84	125.84	2200.0
2008-04-09 08:00:00	DIA	ETF	126.02	126.06	125.83	126.01	13100.0
2008-04-09 09:00:00	DIA	ETF	125.95	126.2	125.61	125.67	1455997.0
2008-04-09 10:00:00	DIA	ETF	125.69	125.76	125.26	125.57	2866109.0
2008-04-09 11:00:00	DIA	ETF	125.56	125.66	124.87	124.93	2070808.0

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

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