PREVIEW / etf_1hour / 2010-04-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-21.parquet
  size:    160 KB
  rows:    4,889

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
2010-04-21 04:00:00	SPY	ETF	121.1	121.1	121.05	121.05	600.0
2010-04-21 05:00:00	SPY	ETF	121.11	121.11	121.04	121.11	5357.0
2010-04-21 06:00:00	SPY	ETF	121.04	121.04	120.79	120.79	44743.0
2010-04-21 07:00:00	SPY	ETF	120.81	120.86	120.67	120.82	623433.0
2010-04-21 08:00:00	SPY	ETF	120.84	120.98	120.75	120.88	2304009.0
2010-04-21 09:00:00	SPY	ETF	120.87	121.23	120.85	121.18	21957523.0
2010-04-21 10:00:00	SPY	ETF	121.18	121.19	120.71	120.7875	30757590.0
2010-04-21 11:00:00	SPY	ETF	120.785	120.88	120.31	120.66	30750445.0
2010-04-21 12:00:00	SPY	ETF	120.66	120.99	120.5115	120.7525	19527701.0
2010-04-21 13:00:00	SPY	ETF	120.75	120.84	120.55	120.805	14520490.0
2010-04-21 14:00:00	SPY	ETF	120.81	120.83	119.99	120.31	30111830.0
2010-04-21 15:00:00	SPY	ETF	120.31	120.89	120.29	120.65	33649493.0
2010-04-21 16:00:00	SPY	ETF	120.64	121.18	120.11	120.23	7369532.0
2010-04-21 17:00:00	SPY	ETF	120.24	120.26	120.18	120.22	112616.0
2010-04-21 18:00:00	SPY	ETF	120.22	120.28	120.19	120.25	54120.0
2010-04-21 19:00:00	SPY	ETF	120.25	120.32	120.21	120.31	73060.0
2010-04-21 04:00:00	QQQ	ETF	50.1	50.1	50.1	50.1	100.0
2010-04-21 05:00:00	QQQ	ETF	50.08	50.08	50.08	50.08	500.0
2010-04-21 06:00:00	QQQ	ETF	50.05	50.05	50.0	50.0	54900.0
2010-04-21 07:00:00	QQQ	ETF	50.0	50.03	49.93	50.03	806403.0
2010-04-21 08:00:00	QQQ	ETF	50.03	50.18	49.97	50.09	1503881.0
2010-04-21 09:00:00	QQQ	ETF	50.09	50.19	50.0	50.14	11159909.0
2010-04-21 10:00:00	QQQ	ETF	50.14	50.15	49.865	49.92	16155219.0
2010-04-21 11:00:00	QQQ	ETF	49.92	49.96	49.725	49.88	10269425.0
2010-04-21 12:00:00	QQQ	ETF	49.89	50.02	49.86	49.96	4019240.0
2010-04-21 13:00:00	QQQ	ETF	49.95	50.03	49.7771	50.02	6018343.0
2010-04-21 14:00:00	QQQ	ETF	50.01	50.01	49.77	49.9	7834879.0
2010-04-21 15:00:00	QQQ	ETF	49.9	50.09	49.9	50.03	10197631.0
2010-04-21 16:00:00	QQQ	ETF	50.03	50.06	49.68	49.74	4166466.0
2010-04-21 17:00:00	QQQ	ETF	49.73	49.75	49.7	49.75	218844.0
2010-04-21 18:00:00	QQQ	ETF	49.74	49.75	49.74	49.74	45834.0
2010-04-21 19:00:00	QQQ	ETF	49.76	49.78	49.75	49.78	4960.0
2010-04-21 06:00:00	IWM	ETF	72.08	72.11	72.07	72.11	4100.0
2010-04-21 07:00:00	IWM	ETF	72.08	72.12	71.97	72.06	116166.0
2010-04-21 08:00:00	IWM	ETF	72.11	72.4	71.98	72.16	194813.0
2010-04-21 09:00:00	IWM	ETF	72.16	72.4	72.03	72.39	5785377.0
2010-04-21 10:00:00	IWM	ETF	72.4	72.4	72.0	72.18	9605868.0
2010-04-21 11:00:00	IWM	ETF	72.18	72.3	71.97	72.19	6710623.0
2010-04-21 12:00:00	IWM	ETF	72.19	72.4	72.14	72.33	4109988.0
2010-04-21 13:00:00	IWM	ETF	72.33	72.44	72.17	72.41	4746746.0
2010-04-21 14:00:00	IWM	ETF	72.41	72.45	71.92	72.27	9135123.0
2010-04-21 15:00:00	IWM	ETF	72.27	72.72	72.2	72.59	14861351.0
2010-04-21 16:00:00	IWM	ETF	72.59	72.6385	72.1544	72.28	2247706.0
2010-04-21 17:00:00	IWM	ETF	72.3	72.31	72.22	72.22	23140.0
2010-04-21 18:00:00	IWM	ETF	72.22	72.31	72.21	72.31	4052.0
2010-04-21 19:00:00	IWM	ETF	72.32	72.33	72.21	72.3	3357.0
2010-04-21 06:00:00	DIA	ETF	111.0	111.0	110.97	110.97	4500.0
2010-04-21 07:00:00	DIA	ETF	111.0	111.04	110.93	110.99	16200.0
2010-04-21 08:00:00	DIA	ETF	111.06	111.14	111.06	111.08	18600.0
2010-04-21 09:00:00	DIA	ETF	111.14	111.48	111.11	111.44	1009158.0

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

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