PREVIEW / etf_1hour / 2008-12-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-22.parquet
  size:    126 KB
  rows:    3,884

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-12-22 04:00:00	SPY	ETF	88.15	88.15	88.07	88.13	3987.0
2008-12-22 05:00:00	SPY	ETF	87.81	88.05	87.81	88.04	760.0
2008-12-22 06:00:00	SPY	ETF	88.06	88.88	88.06	88.88	30550.0
2008-12-22 07:00:00	SPY	ETF	88.8	88.88	88.54	88.7	270490.0
2008-12-22 08:00:00	SPY	ETF	88.69	88.99	88.49	88.55	1197395.0
2008-12-22 09:00:00	SPY	ETF	88.54	89.15	87.78	88.02	19850234.0
2008-12-22 10:00:00	SPY	ETF	88.02	88.5	87.51	87.95	22283604.0
2008-12-22 11:00:00	SPY	ETF	87.95	87.95	86.91	87.3293	23469515.0
2008-12-22 12:00:00	SPY	ETF	87.32	87.52	87.01	87.36	16321886.0
2008-12-22 13:00:00	SPY	ETF	87.37	87.58	86.8	86.95	19800939.0
2008-12-22 14:00:00	SPY	ETF	86.95	87.12	86.02	86.08	39141358.0
2008-12-22 15:00:00	SPY	ETF	86.08	87.09	85.49	86.95	73899319.0
2008-12-22 16:00:00	SPY	ETF	86.81	88.6041	85.64	87.32	13827329.0
2008-12-22 17:00:00	SPY	ETF	87.32	87.36	87.14	87.25	322623.0
2008-12-22 18:00:00	SPY	ETF	87.17	87.27	87.04	87.22	289993.0
2008-12-22 19:00:00	SPY	ETF	87.22	87.44	87.22	87.38	97846.0
2008-12-22 05:00:00	QQQ	ETF	29.6	29.67	29.58	29.67	500.0
2008-12-22 06:00:00	QQQ	ETF	29.74	29.9	29.74	29.9	3100.0
2008-12-22 07:00:00	QQQ	ETF	29.91	29.94	29.85	29.9	47364.0
2008-12-22 08:00:00	QQQ	ETF	29.9	30.0	29.79	29.82	712606.0
2008-12-22 09:00:00	QQQ	ETF	29.81	29.93	29.44	29.53	11142533.0
2008-12-22 10:00:00	QQQ	ETF	29.52	29.57	29.36	29.53	9786403.0
2008-12-22 11:00:00	QQQ	ETF	29.53	29.54	29.16	29.2901	9856012.0
2008-12-22 12:00:00	QQQ	ETF	29.29	29.3	29.16	29.26	5802056.0
2008-12-22 13:00:00	QQQ	ETF	29.25	29.32	29.05	29.0999	7685824.0
2008-12-22 14:00:00	QQQ	ETF	29.1	29.18	28.84	28.87	13198177.0
2008-12-22 15:00:00	QQQ	ETF	28.86	29.28	28.74	29.26	24739824.0
2008-12-22 16:00:00	QQQ	ETF	29.26	29.47	29.14	29.38	4156122.0
2008-12-22 17:00:00	QQQ	ETF	29.36	29.37	29.3	29.34	112650.0
2008-12-22 18:00:00	QQQ	ETF	29.32	29.33	29.27	29.31	44760.0
2008-12-22 19:00:00	QQQ	ETF	29.31	29.39	29.31	29.37	10504.0
2008-12-22 06:00:00	IWM	ETF	48.97	49.15	48.97	49.15	1400.0
2008-12-22 07:00:00	IWM	ETF	49.12	49.21	49.05	49.11	17900.0
2008-12-22 08:00:00	IWM	ETF	49.07	49.28	49.02	49.12	354562.0
2008-12-22 09:00:00	IWM	ETF	49.11	49.11	47.902	47.98	7617682.0
2008-12-22 10:00:00	IWM	ETF	47.98	48.11	47.62	48.01	8317370.0
2008-12-22 11:00:00	IWM	ETF	48.01	48.1	47.29	47.4999	6352777.0
2008-12-22 12:00:00	IWM	ETF	47.49	47.49	47.09	47.21	4586597.0
2008-12-22 13:00:00	IWM	ETF	47.21	47.35	46.88	46.95	5883709.0
2008-12-22 14:00:00	IWM	ETF	46.94	47.11	46.19	46.32	11760387.0
2008-12-22 15:00:00	IWM	ETF	46.32	47.75	46.12	47.74	23884408.0
2008-12-22 16:00:00	IWM	ETF	47.75	48.67	47.1755	48.11	3763498.0
2008-12-22 17:00:00	IWM	ETF	48.06	48.06	47.71	47.96	1211716.0
2008-12-22 18:00:00	IWM	ETF	47.91	47.91	47.91	47.91	192.0
2008-12-22 06:00:00	DIA	ETF	85.45	86.02	85.45	86.02	2069.0
2008-12-22 07:00:00	DIA	ETF	85.9	86.07	85.82	85.84	7800.0
2008-12-22 08:00:00	DIA	ETF	85.91	86.15	85.69	85.73	42253.0
2008-12-22 09:00:00	DIA	ETF	85.65	85.9285	85.41	85.67	2002279.0
2008-12-22 10:00:00	DIA	ETF	85.68	85.76	85.15	85.6185	1754267.0
2008-12-22 11:00:00	DIA	ETF	85.6	85.61	84.81	85.19	1469647.0

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

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