PREVIEW / etf_1hour / 2009-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-20.parquet
  size:    136 KB
  rows:    4,215

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
2009-04-20 04:00:00	SPY	ETF	86.42	86.46	86.22	86.29	15952.0
2009-04-20 05:00:00	SPY	ETF	86.28	86.28	85.88	85.92	55621.0
2009-04-20 06:00:00	SPY	ETF	85.86	86.17	85.86	86.09	167844.0
2009-04-20 07:00:00	SPY	ETF	86.17	86.25	85.71	85.75	1502057.0
2009-04-20 08:00:00	SPY	ETF	85.75	86.09	85.36	85.54	4134213.0
2009-04-20 09:00:00	SPY	ETF	85.54	85.78	84.85	84.97	30420129.0
2009-04-20 10:00:00	SPY	ETF	84.9601	85.03	84.18	84.29	40856278.0
2009-04-20 11:00:00	SPY	ETF	84.29	84.44	84.08	84.17	30839773.0
2009-04-20 12:00:00	SPY	ETF	84.17	85.25	83.97	84.21	26977924.0
2009-04-20 13:00:00	SPY	ETF	84.21	85.1	83.71	83.97	22143684.0
2009-04-20 14:00:00	SPY	ETF	83.96	84.25	83.51	83.5501	28014393.0
2009-04-20 15:00:00	SPY	ETF	83.56	87.0489	83.34	83.41	70174558.0
2009-04-20 16:00:00	SPY	ETF	83.43	87.0489	83.4	83.79	22945702.0
2009-04-20 17:00:00	SPY	ETF	83.8	87.0489	83.72	83.74	5005658.0
2009-04-20 18:00:00	SPY	ETF	83.78	83.79	83.71	83.74	69214.0
2009-04-20 19:00:00	SPY	ETF	83.74	83.81	83.72	83.76	66801.0
2009-04-20 04:00:00	QQQ	ETF	33.04	33.04	33.03	33.03	989.0
2009-04-20 05:00:00	QQQ	ETF	32.89	32.89	32.83	32.83	5484.0
2009-04-20 06:00:00	QQQ	ETF	32.8	32.8	32.74	32.74	51200.0
2009-04-20 07:00:00	QQQ	ETF	32.78	32.84	32.67	32.67	518668.0
2009-04-20 08:00:00	QQQ	ETF	32.68	32.75	32.61	32.66	1483121.0
2009-04-20 09:00:00	QQQ	ETF	32.66	32.82	32.55	32.58	18219047.0
2009-04-20 10:00:00	QQQ	ETF	32.58	32.59	32.18	32.25	21046509.0
2009-04-20 11:00:00	QQQ	ETF	32.24	32.37	32.17	32.22	14095915.0
2009-04-20 12:00:00	QQQ	ETF	32.21	32.35	32.15	32.3399	10823176.0
2009-04-20 13:00:00	QQQ	ETF	32.33	32.33	32.19	32.3	7193828.0
2009-04-20 14:00:00	QQQ	ETF	32.29	32.32	32.09	32.13	10413683.0
2009-04-20 15:00:00	QQQ	ETF	32.1201	32.34	32.06	32.23	23949495.0
2009-04-20 16:00:00	QQQ	ETF	32.23	32.42	32.1694	32.35	10371769.0
2009-04-20 17:00:00	QQQ	ETF	32.36	32.4	32.33	32.34	97770.0
2009-04-20 18:00:00	QQQ	ETF	32.34	32.36	32.29	32.33	45758.0
2009-04-20 19:00:00	QQQ	ETF	32.33	32.34	32.31	32.31	249035.0
2009-04-20 06:00:00	IWM	ETF	47.13	47.14	47.12	47.12	2700.0
2009-04-20 07:00:00	IWM	ETF	47.14	47.14	46.81	46.87	141141.0
2009-04-20 08:00:00	IWM	ETF	46.86	47.2	46.67	46.75	132838.0
2009-04-20 09:00:00	IWM	ETF	46.74	47.0	46.23	46.36	5724329.0
2009-04-20 10:00:00	IWM	ETF	46.36	46.36	45.59	45.64	7758667.0
2009-04-20 11:00:00	IWM	ETF	45.64	45.78	45.5	45.62	4405261.0
2009-04-20 12:00:00	IWM	ETF	45.63	45.66	45.37	45.5103	3548312.0
2009-04-20 13:00:00	IWM	ETF	45.51	45.61	45.31	45.55	3650374.0
2009-04-20 14:00:00	IWM	ETF	45.54	45.64	45.24	45.32	5719651.0
2009-04-20 15:00:00	IWM	ETF	45.32	45.66	45.2	45.29	15263762.0
2009-04-20 16:00:00	IWM	ETF	45.29	47.9219	45.26	47.9219	6343491.0
2009-04-20 17:00:00	IWM	ETF	45.6	45.64	45.57	45.61	3400.0
2009-04-20 18:00:00	IWM	ETF	45.61	45.64	45.59	45.64	1600.0
2009-04-20 19:00:00	IWM	ETF	45.44	45.44	45.38	45.38	4400.0
2009-04-20 06:00:00	DIA	ETF	80.38	80.51	80.38	80.47	29832.0
2009-04-20 07:00:00	DIA	ETF	80.5	80.52	80.28	80.28	8824.0
2009-04-20 08:00:00	DIA	ETF	80.17	80.3	79.87	80.02	98352.0
2009-04-20 09:00:00	DIA	ETF	80.03	80.2	79.4	79.5	2059253.0

> showing 50 of 4,215 rows — these rows as CSV

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