PREVIEW / etf_1hour / 2008-08-13

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-13.parquet
  size:    110 KB
  rows:    3,523

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-08-13 05:00:00	SPY	ETF	129.24	129.24	129.24	129.24	2500.0
2008-08-13 06:00:00	SPY	ETF	129.1	129.27	129.08	129.11	333400.0
2008-08-13 07:00:00	SPY	ETF	129.11	129.19	128.83	128.86	629098.0
2008-08-13 08:00:00	SPY	ETF	128.86	129.25	128.47	128.68	3945597.0
2008-08-13 09:00:00	SPY	ETF	128.69	128.94	128.23	128.5	27973880.0
2008-08-13 10:00:00	SPY	ETF	128.5	129.35	128.03	128.38	43813076.0
2008-08-13 11:00:00	SPY	ETF	128.37	128.38	127.7225	127.87	29493992.0
2008-08-13 12:00:00	SPY	ETF	127.86	128.25	127.67	128.2	21404572.0
2008-08-13 13:00:00	SPY	ETF	128.2	129.05	127.95	128.9499	37758185.0
2008-08-13 14:00:00	SPY	ETF	128.95	129.61	128.58	129.48	34354888.0
2008-08-13 15:00:00	SPY	ETF	129.49	129.65	128.34	128.82	50804524.0
2008-08-13 16:00:00	SPY	ETF	128.82	129.4	127.8244	128.66	3780678.0
2008-08-13 17:00:00	SPY	ETF	128.65	128.69	128.63	128.69	38573.0
2008-08-13 18:00:00	SPY	ETF	128.7	128.77	128.64	128.77	64698.0
2008-08-13 19:00:00	SPY	ETF	128.68	128.77	128.65	128.75	69938.0
2008-08-13 04:00:00	QQQ	ETF	47.73	47.73	47.73	47.73	400.0
2008-08-13 05:00:00	QQQ	ETF	47.7	47.7	47.7	47.7	200.0
2008-08-13 06:00:00	QQQ	ETF	47.74	47.8	47.74	47.76	45700.0
2008-08-13 07:00:00	QQQ	ETF	47.8	47.84	47.72	47.74	569400.0
2008-08-13 08:00:00	QQQ	ETF	47.74	47.83	47.65	47.68	2817250.0
2008-08-13 09:00:00	QQQ	ETF	47.68	47.9	47.61	47.7	18586567.0
2008-08-13 10:00:00	QQQ	ETF	47.7	47.93	47.53	47.72	29169200.0
2008-08-13 11:00:00	QQQ	ETF	47.72	47.73	47.26	47.3	21941843.0
2008-08-13 12:00:00	QQQ	ETF	47.2999	47.45	47.25	47.4074	14528961.0
2008-08-13 13:00:00	QQQ	ETF	47.41	47.75	47.31	47.73	22107411.0
2008-08-13 14:00:00	QQQ	ETF	47.73	48.06	47.6	48.05	25538707.0
2008-08-13 15:00:00	QQQ	ETF	48.05	48.12	47.58	47.78	29606567.0
2008-08-13 16:00:00	QQQ	ETF	47.79	47.83	47.62	47.7	2204173.0
2008-08-13 17:00:00	QQQ	ETF	47.7	47.74	47.69	47.71	19821.0
2008-08-13 18:00:00	QQQ	ETF	47.71	47.74	47.71	47.72	8360.0
2008-08-13 19:00:00	QQQ	ETF	47.74	47.75	47.72	47.75	8222.0
2008-08-13 05:00:00	IWM	ETF	74.53	74.53	74.47	74.47	4200.0
2008-08-13 06:00:00	IWM	ETF	74.47	74.51	74.43	74.5	91800.0
2008-08-13 07:00:00	IWM	ETF	74.45	74.52	74.35	74.35	239694.0
2008-08-13 08:00:00	IWM	ETF	74.37	74.45	73.86	74.24	1553664.0
2008-08-13 09:00:00	IWM	ETF	74.24	74.47	74.04	74.3	12579685.0
2008-08-13 10:00:00	IWM	ETF	74.29	74.53	74.12	74.3	21648315.0
2008-08-13 11:00:00	IWM	ETF	74.3	74.32	73.6	73.68	23516884.0
2008-08-13 12:00:00	IWM	ETF	73.68	73.95	73.53	73.92	12362781.0
2008-08-13 13:00:00	IWM	ETF	73.91	74.6	73.78	74.47	21114222.0
2008-08-13 14:00:00	IWM	ETF	74.47	74.94	74.33	74.89	19280496.0
2008-08-13 15:00:00	IWM	ETF	74.89	74.95	74.43	74.6	26462703.0
2008-08-13 16:00:00	IWM	ETF	74.64	74.64	74.3	74.33	7017514.0
2008-08-13 17:00:00	IWM	ETF	74.33	74.59	74.33	74.59	1512525.0
2008-08-13 18:00:00	IWM	ETF	74.58	74.6	74.58	74.58	10778.0
2008-08-13 19:00:00	IWM	ETF	74.58	74.58	74.58	74.58	5000.0
2008-08-13 05:00:00	DIA	ETF	116.62	116.62	116.58	116.58	400.0
2008-08-13 07:00:00	DIA	ETF	116.55	116.55	116.32	116.33	19841.0
2008-08-13 08:00:00	DIA	ETF	116.27	116.38	115.94	116.06	169521.0
2008-08-13 09:00:00	DIA	ETF	116.07	116.18	115.31	115.59	3510805.0

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

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