PREVIEW / etf_1hour / 2008-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-13.parquet
  size:    103 KB
  rows:    3,277

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-05-13 05:00:00	SPY	ETF	140.1	140.1	140.0	140.03	90000.0
2008-05-13 06:00:00	SPY	ETF	140.12	140.18	139.85	140.11	488400.0
2008-05-13 07:00:00	SPY	ETF	140.12	140.16	139.95	140.08	902936.0
2008-05-13 08:00:00	SPY	ETF	140.09	141.11	140.05	140.93	9192504.0
2008-05-13 09:00:00	SPY	ETF	140.96	140.96	140.17	140.23	22887004.0
2008-05-13 10:00:00	SPY	ETF	140.24	140.6	139.81	139.92	26566320.0
2008-05-13 11:00:00	SPY	ETF	139.92	140.18	139.73	140.13	21807854.0
2008-05-13 12:00:00	SPY	ETF	140.13	140.43	140.0	140.16	18368352.0
2008-05-13 13:00:00	SPY	ETF	140.15	140.47	140.01	140.3	14768647.0
2008-05-13 14:00:00	SPY	ETF	140.29	140.65	140.25	140.6	12423909.0
2008-05-13 15:00:00	SPY	ETF	140.6	140.78	140.23	140.4	25275410.0
2008-05-13 16:00:00	SPY	ETF	140.44	140.56	139.72	140.37	4857714.0
2008-05-13 17:00:00	SPY	ETF	140.37	140.48	139.7711	140.48	82347.0
2008-05-13 18:00:00	SPY	ETF	140.43	140.47	140.39	140.39	11423.0
2008-05-13 19:00:00	SPY	ETF	140.4	140.43	140.37	140.43	8323.0
2008-05-13 05:00:00	QQQ	ETF	48.98	48.98	48.98	48.98	2000.0
2008-05-13 06:00:00	QQQ	ETF	48.96	48.96	48.93	48.94	7200.0
2008-05-13 07:00:00	QQQ	ETF	49.01	49.01	48.89	48.96	173478.0
2008-05-13 08:00:00	QQQ	ETF	48.95	49.2	48.95	49.17	1599715.0
2008-05-13 09:00:00	QQQ	ETF	49.18	49.2	48.94	48.9901	12051220.0
2008-05-13 10:00:00	QQQ	ETF	49.0	49.19	48.83	48.84	17577855.0
2008-05-13 11:00:00	QQQ	ETF	48.845	48.93	48.76	48.89	9069045.0
2008-05-13 12:00:00	QQQ	ETF	48.9	49.07	48.89	48.95	6778466.0
2008-05-13 13:00:00	QQQ	ETF	48.95	49.1	48.9	49.04	7556444.0
2008-05-13 14:00:00	QQQ	ETF	49.04	49.27	49.03	49.2425	8646217.0
2008-05-13 15:00:00	QQQ	ETF	49.25	49.33	49.16	49.2301	14998793.0
2008-05-13 16:00:00	QQQ	ETF	49.22	49.28	49.0489	49.19	6137429.0
2008-05-13 17:00:00	QQQ	ETF	49.22	49.25	49.2	49.21	114817.0
2008-05-13 18:00:00	QQQ	ETF	49.22	49.23	49.2	49.22	26218.0
2008-05-13 19:00:00	QQQ	ETF	49.22	49.23	49.2	49.2	25587.0
2008-05-13 06:00:00	IWM	ETF	72.84	72.84	72.84	72.84	100.0
2008-05-13 07:00:00	IWM	ETF	72.9	72.94	72.85	72.93	14038.0
2008-05-13 08:00:00	IWM	ETF	72.95	73.48	72.92	73.4	345306.0
2008-05-13 09:00:00	IWM	ETF	73.36	73.37	72.89	72.94	4763300.0
2008-05-13 10:00:00	IWM	ETF	72.94	73.21	72.75	72.85	8374130.0
2008-05-13 11:00:00	IWM	ETF	72.84	73.12	72.72	73.07	5126716.0
2008-05-13 12:00:00	IWM	ETF	73.08	73.23	73.01	73.08	4337726.0
2008-05-13 13:00:00	IWM	ETF	73.08	73.41	72.97	73.31	3525550.0
2008-05-13 14:00:00	IWM	ETF	73.3	73.58	73.28	73.57	4982523.0
2008-05-13 15:00:00	IWM	ETF	73.56	73.64	73.32	73.45	11140214.0
2008-05-13 16:00:00	IWM	ETF	73.44	73.55	73.2	73.4	5250714.0
2008-05-13 17:00:00	IWM	ETF	73.42	73.42	73.38	73.38	14711.0
2008-05-13 06:00:00	DIA	ETF	128.43	128.46	128.43	128.44	1100.0
2008-05-13 07:00:00	DIA	ETF	128.41	128.41	128.34	128.4	1650.0
2008-05-13 08:00:00	DIA	ETF	128.47	129.17	128.4	129.14	54516.0
2008-05-13 09:00:00	DIA	ETF	129.14	129.15	128.47	128.51	859330.0
2008-05-13 10:00:00	DIA	ETF	128.51	128.66	128.07	128.12	1341839.0
2008-05-13 11:00:00	DIA	ETF	128.1	128.24	127.9	128.15	1268015.0
2008-05-13 12:00:00	DIA	ETF	128.15	128.57	128.05	128.12	1034587.0
2008-05-13 13:00:00	DIA	ETF	128.12	128.39	127.98	128.28	1043810.0

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

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