PREVIEW / etf_1hour / 2009-06-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-17.parquet
  size:    136 KB
  rows:    4,187

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-06-17 04:00:00	SPY	ETF	91.75	91.81	91.75	91.81	700.0
2009-06-17 05:00:00	SPY	ETF	91.75	91.75	91.63	91.72	8740.0
2009-06-17 06:00:00	SPY	ETF	91.56	91.74	91.49	91.7	119750.0
2009-06-17 07:00:00	SPY	ETF	91.64	92.06	91.28	91.36	2700723.0
2009-06-17 08:00:00	SPY	ETF	91.36	92.03	91.33	91.71	5115784.0
2009-06-17 09:00:00	SPY	ETF	91.7	91.81	91.17	91.22	33613433.0
2009-06-17 10:00:00	SPY	ETF	91.22	91.65	90.83	91.12	44820727.0
2009-06-17 11:00:00	SPY	ETF	91.1282	91.59	91.0	91.58	27563738.0
2009-06-17 12:00:00	SPY	ETF	91.57	92.03	91.55	91.71	22494785.0
2009-06-17 13:00:00	SPY	ETF	91.7	92.31	91.61	92.12	18214333.0
2009-06-17 14:00:00	SPY	ETF	92.12	92.33	91.76	91.89	19516093.0
2009-06-17 15:00:00	SPY	ETF	91.89	92.05	91.41	91.57	40227637.0
2009-06-17 16:00:00	SPY	ETF	91.57	91.9604	91.39	91.52	7264752.0
2009-06-17 17:00:00	SPY	ETF	91.54	91.56	91.44	91.49	268991.0
2009-06-17 18:00:00	SPY	ETF	91.49	91.56	91.48	91.55	30182.0
2009-06-17 19:00:00	SPY	ETF	91.56	91.87	91.55	91.85	93555.0
2009-06-17 05:00:00	QQQ	ETF	35.59	35.61	35.59	35.61	200.0
2009-06-17 06:00:00	QQQ	ETF	35.61	35.62	35.58	35.6	3100.0
2009-06-17 07:00:00	QQQ	ETF	35.68	35.8	35.6	35.62	840143.0
2009-06-17 08:00:00	QQQ	ETF	35.78	35.78	35.6	35.71	2605689.0
2009-06-17 09:00:00	QQQ	ETF	35.71	35.79	35.49	35.505	26355392.0
2009-06-17 10:00:00	QQQ	ETF	35.5	35.76	35.45	35.61	26992548.0
2009-06-17 11:00:00	QQQ	ETF	35.6	35.88	35.6	35.84	22000329.0
2009-06-17 12:00:00	QQQ	ETF	35.85	36.04	35.8	35.9095	14801166.0
2009-06-17 13:00:00	QQQ	ETF	35.91	36.21	35.5	36.13	12303302.0
2009-06-17 14:00:00	QQQ	ETF	36.13	36.19	35.95	36.01	12231362.0
2009-06-17 15:00:00	QQQ	ETF	36.01	36.06	35.81	35.87	20283353.0
2009-06-17 16:00:00	QQQ	ETF	35.87	36.0876	35.5428	35.5428	7470638.0
2009-06-17 17:00:00	QQQ	ETF	35.82	35.84	35.8	35.82	150915.0
2009-06-17 18:00:00	QQQ	ETF	35.82	35.85	35.79	35.8	64539.0
2009-06-17 19:00:00	QQQ	ETF	35.8	35.91	35.8	35.91	77400.0
2009-06-17 07:00:00	IWM	ETF	50.62	50.84	50.45	50.45	290230.0
2009-06-17 08:00:00	IWM	ETF	50.43	50.64	50.38	50.59	133660.0
2009-06-17 09:00:00	IWM	ETF	50.59	50.73	50.07	50.09	8730997.0
2009-06-17 10:00:00	IWM	ETF	50.08	50.54	50.0	50.46	13743349.0
2009-06-17 11:00:00	IWM	ETF	50.45	50.78	50.41	50.72	8747161.0
2009-06-17 12:00:00	IWM	ETF	50.735	51.09	50.735	50.84	8263071.0
2009-06-17 13:00:00	IWM	ETF	50.83	51.37	50.78	51.19	5911120.0
2009-06-17 14:00:00	IWM	ETF	51.19	51.33	50.9	51.04	5214286.0
2009-06-17 15:00:00	IWM	ETF	51.04	51.11	50.491	50.81	13525242.0
2009-06-17 16:00:00	IWM	ETF	50.81	50.85	50.67	50.78	1470934.0
2009-06-17 17:00:00	IWM	ETF	50.76	50.8	50.491	50.79	3005137.0
2009-06-17 18:00:00	IWM	ETF	50.8	50.84	50.8	50.8	3750.0
2009-06-17 19:00:00	IWM	ETF	50.95	50.97	50.89	50.89	300.0
2009-06-17 07:00:00	DIA	ETF	85.38	85.58	85.01	85.01	19300.0
2009-06-17 08:00:00	DIA	ETF	85.09	85.39	85.07	85.36	37664.0
2009-06-17 09:00:00	DIA	ETF	85.28	85.54	85.08	85.11	1904989.0
2009-06-17 10:00:00	DIA	ETF	85.1	85.45	84.831	85.0	2799240.0
2009-06-17 11:00:00	DIA	ETF	85.0	85.4	84.99	85.36	2621807.0
2009-06-17 12:00:00	DIA	ETF	85.37	85.71	85.32	85.42	1627494.0

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

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