PREVIEW / etf_1hour / 2009-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-28.parquet
  size:    136 KB
  rows:    4,193

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-05-28 04:00:00	SPY	ETF	89.93	90.04	89.93	90.04	14465.0
2009-05-28 05:00:00	SPY	ETF	90.09	90.19	90.06	90.06	4000.0
2009-05-28 06:00:00	SPY	ETF	90.1	90.1	89.92	89.92	45000.0
2009-05-28 07:00:00	SPY	ETF	90.0	90.13	89.59	89.68	660138.0
2009-05-28 08:00:00	SPY	ETF	89.73	90.15	89.68	89.99	4748736.0
2009-05-28 09:00:00	SPY	ETF	89.98	90.7	89.86	90.225	27363489.0
2009-05-28 10:00:00	SPY	ETF	90.21	90.45	89.1	89.89	51068428.0
2009-05-28 11:00:00	SPY	ETF	89.9	90.61	89.5	90.52	34698807.0
2009-05-28 12:00:00	SPY	ETF	90.52	90.6	89.67	89.77	29584773.0
2009-05-28 13:00:00	SPY	ETF	89.78	91.03	89.7	90.66	52860345.0
2009-05-28 14:00:00	SPY	ETF	90.64	91.34	90.59	91.11	32781618.0
2009-05-28 15:00:00	SPY	ETF	91.11	91.26	90.63	90.95	41622226.0
2009-05-28 16:00:00	SPY	ETF	90.95	91.04	90.1	90.98	11925928.0
2009-05-28 17:00:00	SPY	ETF	90.97	91.06	90.93	90.96	42211.0
2009-05-28 18:00:00	SPY	ETF	90.96	90.96	90.85	90.89	52936.0
2009-05-28 19:00:00	SPY	ETF	90.89	90.95	90.85	90.92	20985.0
2009-05-28 05:00:00	QQQ	ETF	34.73	34.75	34.72	34.72	1400.0
2009-05-28 06:00:00	QQQ	ETF	34.68	34.7	34.67	34.67	708.0
2009-05-28 07:00:00	QQQ	ETF	34.68	34.71	34.54	34.57	27846.0
2009-05-28 08:00:00	QQQ	ETF	34.57	34.73	34.53	34.66	1030603.0
2009-05-28 09:00:00	QQQ	ETF	34.67	34.93	34.62	34.68	11887690.0
2009-05-28 10:00:00	QQQ	ETF	34.68	34.7	34.21	34.4999	21637896.0
2009-05-28 11:00:00	QQQ	ETF	34.5	34.74	34.49	34.72	11394777.0
2009-05-28 12:00:00	QQQ	ETF	34.72	34.75	34.42	34.47	11417987.0
2009-05-28 13:00:00	QQQ	ETF	34.47	34.95	34.47	34.82	19758442.0
2009-05-28 14:00:00	QQQ	ETF	34.81	35.07	34.79	35.0	12428190.0
2009-05-28 15:00:00	QQQ	ETF	35.01	35.07	34.84	34.96	21069128.0
2009-05-28 16:00:00	QQQ	ETF	34.96	35.09	34.5224	34.93	4865281.0
2009-05-28 17:00:00	QQQ	ETF	34.93	34.96	34.91	34.95	151728.0
2009-05-28 18:00:00	QQQ	ETF	34.94	34.95	34.9	34.9	13060.0
2009-05-28 19:00:00	QQQ	ETF	34.9	34.91	34.9	34.9	9700.0
2009-05-28 06:00:00	IWM	ETF	49.34	49.34	49.34	49.34	159.0
2009-05-28 07:00:00	IWM	ETF	49.36	49.38	49.05	49.11	43400.0
2009-05-28 08:00:00	IWM	ETF	49.11	49.44	49.03	49.28	740984.0
2009-05-28 09:00:00	IWM	ETF	49.28	49.75	49.12	49.15	6517887.0
2009-05-28 10:00:00	IWM	ETF	49.15	49.17	48.1	48.71	13691760.0
2009-05-28 11:00:00	IWM	ETF	48.72	49.07	48.67	49.0	6327279.0
2009-05-28 12:00:00	IWM	ETF	49.01	49.05	48.38	48.46	4951865.0
2009-05-28 13:00:00	IWM	ETF	48.46	49.28	48.45	48.99	8513676.0
2009-05-28 14:00:00	IWM	ETF	48.99	49.51	48.96	49.29	5673051.0
2009-05-28 15:00:00	IWM	ETF	49.3	49.41	48.99	49.17	8311200.0
2009-05-28 16:00:00	IWM	ETF	49.17	49.2847	48.8931	49.17	2827844.0
2009-05-28 17:00:00	IWM	ETF	49.17	49.17	49.11	49.12	7811.0
2009-05-28 18:00:00	IWM	ETF	49.16	49.16	49.16	49.16	100.0
2009-05-28 19:00:00	IWM	ETF	49.14	49.36	49.13	49.19	1700.0
2009-05-28 06:00:00	DIA	ETF	83.48	83.48	83.48	83.48	600.0
2009-05-28 07:00:00	DIA	ETF	83.48	83.57	83.18	83.18	3400.0
2009-05-28 08:00:00	DIA	ETF	83.18	83.55	83.18	83.41	53286.0
2009-05-28 09:00:00	DIA	ETF	83.4	83.97	83.36	83.55	1487835.0
2009-05-28 10:00:00	DIA	ETF	83.58	83.58	82.53	83.13	3284818.0

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

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