PREVIEW / etf_1hour / 2009-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-31.parquet
  size:    132 KB
  rows:    4,018

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-03-31 04:00:00	SPY	ETF	79.61	79.61	79.5	79.58	13834.0
2009-03-31 05:00:00	SPY	ETF	79.52	79.64	79.46	79.56	4701.0
2009-03-31 06:00:00	SPY	ETF	79.28	79.73	79.22	79.72	138275.0
2009-03-31 07:00:00	SPY	ETF	79.65	79.69	79.45	79.54	890402.0
2009-03-31 08:00:00	SPY	ETF	79.53	79.76	79.1468	79.65	2635348.0
2009-03-31 09:00:00	SPY	ETF	79.65	79.74	79.09	79.24	30615858.0
2009-03-31 10:00:00	SPY	ETF	79.23	79.92	79.05	79.58	54835128.0
2009-03-31 11:00:00	SPY	ETF	79.58	80.03	79.57	79.89	37583876.0
2009-03-31 12:00:00	SPY	ETF	79.8801	79.98	79.55	79.95	20284338.0
2009-03-31 13:00:00	SPY	ETF	79.96	80.43	79.92	80.4	31343172.0
2009-03-31 14:00:00	SPY	ETF	80.4	81.08	79.15	80.81	44719706.0
2009-03-31 15:00:00	SPY	ETF	80.81	80.85	79.44	79.5	107542916.0
2009-03-31 16:00:00	SPY	ETF	79.55	80.26	79.25	79.32	28341582.0
2009-03-31 17:00:00	SPY	ETF	79.28	79.32	78.7586	79.12	3204004.0
2009-03-31 18:00:00	SPY	ETF	79.12	79.13	78.96	78.99	320336.0
2009-03-31 19:00:00	SPY	ETF	78.97	79.25	78.95	79.02	131322.0
2009-03-31 04:00:00	QQQ	ETF	30.46	30.5	30.42	30.42	7050.0
2009-03-31 05:00:00	QQQ	ETF	30.4	30.41	30.4	30.4	1300.0
2009-03-31 06:00:00	QQQ	ETF	30.3	30.43	30.3	30.42	2700.0
2009-03-31 07:00:00	QQQ	ETF	30.44	30.47	30.33	30.37	250258.0
2009-03-31 08:00:00	QQQ	ETF	30.37	30.51	30.2	30.43	1247114.0
2009-03-31 09:00:00	QQQ	ETF	30.42	30.48	30.27	30.35	14075553.0
2009-03-31 10:00:00	QQQ	ETF	30.34	30.56	30.3	30.37	19548225.0
2009-03-31 11:00:00	QQQ	ETF	30.37	30.54	30.37	30.47	11889080.0
2009-03-31 12:00:00	QQQ	ETF	30.46	30.58	30.35	30.55	12443365.0
2009-03-31 13:00:00	QQQ	ETF	30.56	30.69	30.55	30.67	13365551.0
2009-03-31 14:00:00	QQQ	ETF	30.67	30.95	30.64	30.84	16524063.0
2009-03-31 15:00:00	QQQ	ETF	30.85	30.86	30.32	30.33	46941501.0
2009-03-31 16:00:00	QQQ	ETF	30.33	30.5411	30.18	30.21	5036336.0
2009-03-31 17:00:00	QQQ	ETF	30.2	30.2	30.12	30.14	165810.0
2009-03-31 18:00:00	QQQ	ETF	30.14	30.15	30.1	30.1	35727.0
2009-03-31 19:00:00	QQQ	ETF	30.12	30.21	30.1	30.1	78616.0
2009-03-31 06:00:00	IWM	ETF	42.11	42.11	42.11	42.11	200.0
2009-03-31 07:00:00	IWM	ETF	42.1	42.14	41.99	42.12	81900.0
2009-03-31 08:00:00	IWM	ETF	42.12	42.34	42.1	42.24	937392.0
2009-03-31 09:00:00	IWM	ETF	42.22	44.03	41.69	41.8	4833143.0
2009-03-31 10:00:00	IWM	ETF	41.8	42.15	41.61	41.74	8292562.0
2009-03-31 11:00:00	IWM	ETF	41.74	42.2	41.74	42.1	5338826.0
2009-03-31 12:00:00	IWM	ETF	42.1	42.38	41.98	42.34	3019012.0
2009-03-31 13:00:00	IWM	ETF	42.35	42.86	42.34	42.85	6444347.0
2009-03-31 14:00:00	IWM	ETF	42.85	43.31	42.3	42.98	9570123.0
2009-03-31 15:00:00	IWM	ETF	42.98	43.01	42.09	42.11	19111740.0
2009-03-31 16:00:00	IWM	ETF	42.12	42.8	41.5755	41.86	5147975.0
2009-03-31 17:00:00	IWM	ETF	41.86	41.87	41.75	41.83	35200.0
2009-03-31 18:00:00	IWM	ETF	41.88	41.88	41.88	41.88	200.0
2009-03-31 19:00:00	IWM	ETF	41.75	41.88	41.75	41.81	2250.0
2009-03-31 06:00:00	DIA	ETF	76.02	76.15	76.02	76.15	350.0
2009-03-31 07:00:00	DIA	ETF	76.09	76.12	75.97	76.04	40998.0
2009-03-31 08:00:00	DIA	ETF	76.01	76.21	75.99	76.12	86687.0
2009-03-31 09:00:00	DIA	ETF	76.12	76.13	75.56	75.73	2530211.0

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

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