PREVIEW / etf_1hour / 2008-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-01.parquet
  size:    114 KB
  rows:    3,632

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-07-01 04:00:00	SPY	ETF	127.8	127.8	127.5	127.5	200.0
2008-07-01 05:00:00	SPY	ETF	127.34	127.34	126.68	126.68	3900.0
2008-07-01 06:00:00	SPY	ETF	126.67	126.8	126.45	126.6	555700.0
2008-07-01 07:00:00	SPY	ETF	126.6	126.84	126.5	126.65	2570735.0
2008-07-01 08:00:00	SPY	ETF	126.65	127.34	126.51	126.62	3719400.0
2008-07-01 09:00:00	SPY	ETF	126.62	127.98	126.34	127.07	29013062.0
2008-07-01 10:00:00	SPY	ETF	127.06	128.0	126.98	128.0	66608181.0
2008-07-01 11:00:00	SPY	ETF	128.0	128.24	127.04	127.14	39840522.0
2008-07-01 12:00:00	SPY	ETF	127.14	127.14	125.93	126.5001	49507769.0
2008-07-01 13:00:00	SPY	ETF	126.51	127.8891	126.18	126.91	45768180.0
2008-07-01 14:00:00	SPY	ETF	126.91	128.46	126.88	128.0	66922382.0
2008-07-01 15:00:00	SPY	ETF	128.011	128.43	127.64	128.37	49927178.0
2008-07-01 16:00:00	SPY	ETF	128.371	128.5	127.45	128.45	5955629.0
2008-07-01 17:00:00	SPY	ETF	128.45	128.61	127.89	128.56	3148800.0
2008-07-01 18:00:00	SPY	ETF	128.56	128.56	128.47	128.48	32451.0
2008-07-01 19:00:00	SPY	ETF	128.48	128.5	128.39	128.42	8790.0
2008-07-01 04:00:00	QQQ	ETF	45.09	45.09	44.81	44.81	1600.0
2008-07-01 05:00:00	QQQ	ETF	44.77	44.77	44.61	44.66	3200.0
2008-07-01 06:00:00	QQQ	ETF	44.68	44.69	44.5	44.53	35800.0
2008-07-01 07:00:00	QQQ	ETF	44.53	44.66	44.51	44.6	676920.0
2008-07-01 08:00:00	QQQ	ETF	44.62	44.76	44.59	44.74	3056382.0
2008-07-01 09:00:00	QQQ	ETF	44.74	45.17	44.61	44.98	23723339.0
2008-07-01 10:00:00	QQQ	ETF	44.97	45.49	44.93	45.49	44567425.0
2008-07-01 11:00:00	QQQ	ETF	45.49	45.58	45.05	45.1	22118558.0
2008-07-01 12:00:00	QQQ	ETF	45.1	45.14	44.68	44.9301	30503729.0
2008-07-01 13:00:00	QQQ	ETF	44.93	45.45	44.84	45.22	31798566.0
2008-07-01 14:00:00	QQQ	ETF	45.22	45.86	45.21	45.64	42550675.0
2008-07-01 15:00:00	QQQ	ETF	45.6405	45.84	45.47	45.83	27957092.0
2008-07-01 16:00:00	QQQ	ETF	45.82	45.87	45.1732	45.86	13495535.0
2008-07-01 17:00:00	QQQ	ETF	45.85	45.89	45.81	45.86	362052.0
2008-07-01 18:00:00	QQQ	ETF	45.88	45.88	45.81	45.82	39252.0
2008-07-01 19:00:00	QQQ	ETF	45.82	45.86	45.81	45.83	20000.0
2008-07-01 06:00:00	IWM	ETF	68.38	68.44	68.34	68.34	3300.0
2008-07-01 07:00:00	IWM	ETF	68.33	68.52	68.33	68.34	277907.0
2008-07-01 08:00:00	IWM	ETF	68.37	69.03	68.29	68.35	701420.0
2008-07-01 09:00:00	IWM	ETF	68.34	69.03	68.11	68.42	11335674.0
2008-07-01 10:00:00	IWM	ETF	68.42	69.01	68.42	68.73	26474637.0
2008-07-01 11:00:00	IWM	ETF	68.73	68.88	68.15	68.2	13892165.0
2008-07-01 12:00:00	IWM	ETF	68.2	68.2	67.62	67.94	16963692.0
2008-07-01 13:00:00	IWM	ETF	67.94	68.75	67.79	68.35	14446449.0
2008-07-01 14:00:00	IWM	ETF	68.34	69.26	68.32	68.94	22864886.0
2008-07-01 15:00:00	IWM	ETF	68.94	69.25	68.7	69.17	23145648.0
2008-07-01 16:00:00	IWM	ETF	69.15	69.18	68.78	69.14	11146731.0
2008-07-01 17:00:00	IWM	ETF	69.12	69.25	69.11	69.25	5021206.0
2008-07-01 18:00:00	IWM	ETF	69.15	69.15	69.11	69.11	900.0
2008-07-01 19:00:00	IWM	ETF	69.11	69.11	69.11	69.11	500.0
2008-07-01 05:00:00	DIA	ETF	112.99	112.99	112.99	112.99	100.0
2008-07-01 06:00:00	DIA	ETF	112.3	112.5	112.21	112.5	500.0
2008-07-01 07:00:00	DIA	ETF	112.38	112.5	112.27	112.32	19321.0
2008-07-01 08:00:00	DIA	ETF	112.4	112.63	112.38	112.5	174594.0

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

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