PREVIEW / etf_1hour / 2010-04-30

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-30.parquet
  size:    163 KB
  rows:    4,944

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-30 04:00:00	SPY	ETF	121.17	121.19	121.08	121.19	26500.0
2010-04-30 05:00:00	SPY	ETF	121.16	121.19	121.0	121.15	38842.0
2010-04-30 06:00:00	SPY	ETF	121.15	121.16	120.82	120.82	40600.0
2010-04-30 07:00:00	SPY	ETF	120.86	121.21	120.8	121.18	712789.0
2010-04-30 08:00:00	SPY	ETF	121.18	121.19	120.65	120.88	2156752.0
2010-04-30 09:00:00	SPY	ETF	120.88	121.01	120.55	120.56	27501017.0
2010-04-30 10:00:00	SPY	ETF	120.56	120.9	119.84	120.55	56542969.0
2010-04-30 11:00:00	SPY	ETF	120.55	120.9	120.32	120.51	21444119.0
2010-04-30 12:00:00	SPY	ETF	120.5	120.71	119.34	119.45	37204047.0
2010-04-30 13:00:00	SPY	ETF	119.45	120.8367	119.31	119.66	24256302.0
2010-04-30 14:00:00	SPY	ETF	119.67	120.8368	119.19	119.3199	27048920.0
2010-04-30 15:00:00	SPY	ETF	119.31	119.5	118.78	118.83	54732407.0
2010-04-30 16:00:00	SPY	ETF	118.84	120.74	118.78	119.01	13548247.0
2010-04-30 17:00:00	SPY	ETF	119.01	119.05	118.8297	118.99	664678.0
2010-04-30 18:00:00	SPY	ETF	118.99	118.99	118.81	118.81	95891.0
2010-04-30 19:00:00	SPY	ETF	118.81	118.91	118.8	118.89	47651.0
2010-04-30 04:00:00	QQQ	ETF	50.34	50.35	50.34	50.35	1600.0
2010-04-30 05:00:00	QQQ	ETF	50.38	50.38	50.34	50.34	500.0
2010-04-30 06:00:00	QQQ	ETF	50.35	50.35	50.23	50.23	6100.0
2010-04-30 07:00:00	QQQ	ETF	50.22	50.37	50.22	50.37	38400.0
2010-04-30 08:00:00	QQQ	ETF	50.36	50.38	50.27	50.27	371476.0
2010-04-30 09:00:00	QQQ	ETF	50.26	50.29	50.05	50.06	8324637.0
2010-04-30 10:00:00	QQQ	ETF	50.05	50.07	49.82	49.98	21936673.0
2010-04-30 11:00:00	QQQ	ETF	49.98	50.03	49.82	49.881	9815114.0
2010-04-30 12:00:00	QQQ	ETF	49.89	49.91	49.36	49.4096	14500884.0
2010-04-30 13:00:00	QQQ	ETF	49.4	49.62	49.38	49.48	13863918.0
2010-04-30 14:00:00	QQQ	ETF	49.48	49.55	49.34	49.39	8926068.0
2010-04-30 15:00:00	QQQ	ETF	49.39	49.51	49.2	49.24	25126333.0
2010-04-30 16:00:00	QQQ	ETF	49.25	50.2701	49.2	49.28	3273986.0
2010-04-30 17:00:00	QQQ	ETF	49.31	49.35	49.29	49.35	26794.0
2010-04-30 18:00:00	QQQ	ETF	49.29	49.31	49.29	49.31	3130.0
2010-04-30 19:00:00	QQQ	ETF	49.31	49.31	49.28	49.29	9618.0
2010-04-30 06:00:00	IWM	ETF	73.85	73.85	73.83	73.83	1500.0
2010-04-30 07:00:00	IWM	ETF	73.81	74.0	73.8	73.98	65062.0
2010-04-30 08:00:00	IWM	ETF	73.97	74.08	73.83	73.83	304490.0
2010-04-30 09:00:00	IWM	ETF	73.83	73.93	73.49	73.52	7357105.0
2010-04-30 10:00:00	IWM	ETF	73.53	73.66	73.18	73.6	13999862.0
2010-04-30 11:00:00	IWM	ETF	73.6	73.65	73.35	73.44	5943356.0
2010-04-30 12:00:00	IWM	ETF	73.45	73.465	72.57	72.6499	7755387.0
2010-04-30 13:00:00	IWM	ETF	72.65	72.84	72.51	72.582	7682790.0
2010-04-30 14:00:00	IWM	ETF	72.59	72.75	72.26	72.34	9652998.0
2010-04-30 15:00:00	IWM	ETF	72.35	72.49	71.61	71.63	24429870.0
2010-04-30 16:00:00	IWM	ETF	71.63	73.7906	71.56	71.82	5495674.0
2010-04-30 17:00:00	IWM	ETF	71.83	73.7906	71.65	71.8	1037394.0
2010-04-30 18:00:00	IWM	ETF	71.85	71.85	71.78	71.78	4449.0
2010-04-30 19:00:00	IWM	ETF	71.78	71.88	71.78	71.78	4390.0
2010-04-30 07:00:00	DIA	ETF	111.76	112.03	111.76	112.03	7100.0
2010-04-30 08:00:00	DIA	ETF	112.01	112.05	111.83	111.83	61255.0
2010-04-30 09:00:00	DIA	ETF	111.82	112.0	111.61	111.61	1367200.0
2010-04-30 10:00:00	DIA	ETF	111.62	111.78	111.08	111.67	3489546.0

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

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