PREVIEW / etf_1hour / 2009-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-01.parquet
  size:    142 KB
  rows:    4,448

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-01 04:00:00	SPY	ETF	93.72	93.8	93.64	93.76	18857.0
2009-06-01 05:00:00	SPY	ETF	93.83	93.85	93.68	93.83	52200.0
2009-06-01 06:00:00	SPY	ETF	93.83	94.1	93.64	93.66	96000.0
2009-06-01 07:00:00	SPY	ETF	93.64	93.71	93.33	93.44	1050164.0
2009-06-01 08:00:00	SPY	ETF	93.44	93.87	92.44	93.67	4349044.0
2009-06-01 09:00:00	SPY	ETF	93.67	94.24	93.1	94.0	41076872.0
2009-06-01 10:00:00	SPY	ETF	94.02	94.65	94.015	94.58	53066089.0
2009-06-01 11:00:00	SPY	ETF	94.57	94.82	94.51	94.73	18118206.0
2009-06-01 12:00:00	SPY	ETF	94.73	94.91	94.62	94.65	20097052.0
2009-06-01 13:00:00	SPY	ETF	94.66	95.1	94.56	95.0301	18542840.0
2009-06-01 14:00:00	SPY	ETF	95.04	95.17	94.65	94.79	29636469.0
2009-06-01 15:00:00	SPY	ETF	94.78	95.09	94.38	94.77	71667746.0
2009-06-01 16:00:00	SPY	ETF	94.74	94.8205	94.25	94.32	16714555.0
2009-06-01 17:00:00	SPY	ETF	94.31	94.42	94.3	94.41	619820.0
2009-06-01 18:00:00	SPY	ETF	94.38	94.41	94.33	94.35	82209.0
2009-06-01 19:00:00	SPY	ETF	94.35	94.43	94.33	94.43	53574.0
2009-06-01 04:00:00	QQQ	ETF	35.7	35.74	35.69	35.74	1192.0
2009-06-01 05:00:00	QQQ	ETF	35.75	35.83	35.75	35.8	4565.0
2009-06-01 06:00:00	QQQ	ETF	35.8	35.91	35.75	35.77	24050.0
2009-06-01 07:00:00	QQQ	ETF	35.73	35.73	35.64	35.68	534883.0
2009-06-01 08:00:00	QQQ	ETF	35.66	35.82	35.5	35.73	918563.0
2009-06-01 09:00:00	QQQ	ETF	35.73	36.05	35.38	35.98	18810469.0
2009-06-01 10:00:00	QQQ	ETF	35.98	36.26	35.97	36.23	18697756.0
2009-06-01 11:00:00	QQQ	ETF	36.23	36.36	36.22	36.32	13302317.0
2009-06-01 12:00:00	QQQ	ETF	36.32	36.46	36.29	36.33	9218488.0
2009-06-01 13:00:00	QQQ	ETF	36.33	36.48	36.25	36.46	9579465.0
2009-06-01 14:00:00	QQQ	ETF	36.46	36.5	36.31	36.4	12763211.0
2009-06-01 15:00:00	QQQ	ETF	36.4	36.45	36.2	36.41	30113829.0
2009-06-01 16:00:00	QQQ	ETF	36.41	36.42	36.17	36.23	3656721.0
2009-06-01 17:00:00	QQQ	ETF	36.22	36.25	36.21	36.24	29047.0
2009-06-01 18:00:00	QQQ	ETF	36.24	36.24	36.21	36.23	22446.0
2009-06-01 19:00:00	QQQ	ETF	36.23	36.25	36.21	36.24	50981.0
2009-06-01 06:00:00	IWM	ETF	51.15	51.15	51.0	51.0	12000.0
2009-06-01 07:00:00	IWM	ETF	51.05	51.05	50.8	50.92	153784.0
2009-06-01 08:00:00	IWM	ETF	50.92	51.43	50.27	51.36	676758.0
2009-06-01 09:00:00	IWM	ETF	51.36	54.55	50.17	51.59	8582625.0
2009-06-01 10:00:00	IWM	ETF	51.6	52.29	51.595	52.08	13399421.0
2009-06-01 11:00:00	IWM	ETF	52.08	52.2599	52.04	52.19	5619795.0
2009-06-01 12:00:00	IWM	ETF	52.19	52.37	52.15	52.17	5415385.0
2009-06-01 13:00:00	IWM	ETF	52.17	52.365	52.1	52.31	4853008.0
2009-06-01 14:00:00	IWM	ETF	52.31	52.3501	52.0	52.09	7822194.0
2009-06-01 15:00:00	IWM	ETF	52.09	52.3	51.79	52.14	14938972.0
2009-06-01 16:00:00	IWM	ETF	52.13	52.25	50.2418	51.85	5569871.0
2009-06-01 17:00:00	IWM	ETF	51.87	51.93	51.85	51.93	2600.0
2009-06-01 18:00:00	IWM	ETF	51.93	51.95	51.87	51.92	3000.0
2009-06-01 19:00:00	IWM	ETF	51.9	52.0	51.9	52.0	2100.0
2009-06-01 06:00:00	DIA	ETF	86.4	86.4	86.21	86.21	200.0
2009-06-01 07:00:00	DIA	ETF	86.21	86.25	85.92	86.05	13082.0
2009-06-01 08:00:00	DIA	ETF	86.01	86.35	85.99	86.15	136980.0
2009-06-01 09:00:00	DIA	ETF	86.21	86.68	85.39	86.54	1701010.0

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

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