PREVIEW / etf_1hour / 2008-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-07.parquet
  size:    103 KB
  rows:    3,476

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-07 04:00:00	SPY	ETF	137.97	138.15	137.97	138.15	1700.0
2008-04-07 05:00:00	SPY	ETF	137.94	138.14	137.89	138.14	14000.0
2008-04-07 06:00:00	SPY	ETF	138.08	138.15	137.9	137.95	28500.0
2008-04-07 07:00:00	SPY	ETF	137.95	138.02	137.83	138.0	372900.0
2008-04-07 08:00:00	SPY	ETF	137.99	138.05	137.35	137.84	2591500.0
2008-04-07 09:00:00	SPY	ETF	137.84	138.05	137.0	137.89	15930974.0
2008-04-07 10:00:00	SPY	ETF	137.89	137.91	137.3	137.64	16556101.0
2008-04-07 11:00:00	SPY	ETF	137.65	138.24	137.41	138.11	19819791.0
2008-04-07 12:00:00	SPY	ETF	138.1	138.57	138.0	138.39	16706338.0
2008-04-07 13:00:00	SPY	ETF	138.399	138.45	137.78	137.95	14848676.0
2008-04-07 14:00:00	SPY	ETF	137.95	138.0	137.13	137.22	21835127.0
2008-04-07 15:00:00	SPY	ETF	137.22	137.54	136.74	137.05	34888823.0
2008-04-07 16:00:00	SPY	ETF	137.02	137.24	136.4	136.58	8444600.0
2008-04-07 17:00:00	SPY	ETF	136.57	136.73	136.54	136.68	98000.0
2008-04-07 18:00:00	SPY	ETF	136.68	136.8	136.67	136.73	84100.0
2008-04-07 19:00:00	SPY	ETF	136.73	136.75	136.6	136.64	32000.0
2008-04-07 04:00:00	QQQ	ETF	46.19	46.25	46.19	46.25	1200.0
2008-04-07 05:00:00	QQQ	ETF	46.2	46.2	46.2	46.2	1500.0
2008-04-07 06:00:00	QQQ	ETF	46.2	46.2	46.16	46.17	13700.0
2008-04-07 07:00:00	QQQ	ETF	46.18	46.21	46.15	46.18	87840.0
2008-04-07 08:00:00	QQQ	ETF	46.19	46.21	46.08	46.1	1859424.0
2008-04-07 09:00:00	QQQ	ETF	46.1	46.24	46.01	46.24	11906858.0
2008-04-07 10:00:00	QQQ	ETF	46.24	46.27	45.95	46.13	15144912.0
2008-04-07 11:00:00	QQQ	ETF	46.13	46.36	46.04	46.28	10115677.0
2008-04-07 12:00:00	QQQ	ETF	46.28	46.41	46.22	46.26	10460023.0
2008-04-07 13:00:00	QQQ	ETF	46.26	46.29	46.02	46.0625	8673211.0
2008-04-07 14:00:00	QQQ	ETF	46.07	46.1	45.77	45.81	16647966.0
2008-04-07 15:00:00	QQQ	ETF	45.82	45.86	45.65	45.76	22562341.0
2008-04-07 16:00:00	QQQ	ETF	45.76	46.0363	45.57	45.65	3967214.0
2008-04-07 17:00:00	QQQ	ETF	45.64	45.68	45.62	45.66	114038.0
2008-04-07 18:00:00	QQQ	ETF	45.67	45.74	45.65	45.7	274410.0
2008-04-07 19:00:00	QQQ	ETF	45.68	45.72	45.67	45.68	26293.0
2008-04-07 04:00:00	IWM	ETF	71.74	71.74	71.74	71.74	200.0
2008-04-07 05:00:00	IWM	ETF	71.7	71.7	71.7	71.7	500.0
2008-04-07 07:00:00	IWM	ETF	71.67	71.75	71.67	71.7	9300.0
2008-04-07 08:00:00	IWM	ETF	71.69	71.84	71.67	71.67	98500.0
2008-04-07 09:00:00	IWM	ETF	71.65	71.8	71.36	71.7	5723279.0
2008-04-07 10:00:00	IWM	ETF	71.7	71.71	71.15	71.57	3104920.0
2008-04-07 11:00:00	IWM	ETF	71.57	71.75	71.4	71.67	5190817.0
2008-04-07 12:00:00	IWM	ETF	71.66	71.86	71.52	71.74	3593946.0
2008-04-07 13:00:00	IWM	ETF	71.74	71.77	71.44	71.52	2282107.0
2008-04-07 14:00:00	IWM	ETF	71.51	71.53	71.03	71.13	7162702.0
2008-04-07 15:00:00	IWM	ETF	71.12	71.17	70.78	70.95	10876743.0
2008-04-07 16:00:00	IWM	ETF	70.95	71.33	70.72	70.82	1020400.0
2008-04-07 17:00:00	IWM	ETF	70.82	70.88	70.82	70.87	55700.0
2008-04-07 18:00:00	IWM	ETF	70.92	70.95	70.87	70.95	26200.0
2008-04-07 07:00:00	DIA	ETF	126.76	126.89	126.73	126.86	13700.0
2008-04-07 08:00:00	DIA	ETF	126.8	126.9	126.72	126.72	53600.0
2008-04-07 09:00:00	DIA	ETF	126.68	126.9	126.37	126.72	1694681.0
2008-04-07 10:00:00	DIA	ETF	126.73	126.73	126.17	126.46	1277440.0

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

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