PREVIEW / etf_1hour / 2010-03-31

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-31.parquet
  size:    156 KB
  rows:    4,861

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-03-31 04:00:00	SPY	ETF	117.3	117.3	117.3	117.3	2500.0
2010-03-31 05:00:00	SPY	ETF	117.28	117.28	117.27	117.27	300.0
2010-03-31 06:00:00	SPY	ETF	117.18	117.32	117.18	117.3	49977.0
2010-03-31 07:00:00	SPY	ETF	117.3	117.35	117.2	117.32	360398.0
2010-03-31 08:00:00	SPY	ETF	117.33	117.42	116.75	116.91	3152935.0
2010-03-31 09:00:00	SPY	ETF	116.9	117.175	116.61	116.81	28060998.0
2010-03-31 10:00:00	SPY	ETF	116.84	117.35	116.82	117.17	25569863.0
2010-03-31 11:00:00	SPY	ETF	117.17	117.45	116.9	117.38	18270476.0
2010-03-31 12:00:00	SPY	ETF	117.388	117.51	117.28	117.36	10004259.0
2010-03-31 13:00:00	SPY	ETF	117.36	117.43	117.25	117.4	9362002.0
2010-03-31 14:00:00	SPY	ETF	117.4	117.52	117.05	117.13	14662227.0
2010-03-31 15:00:00	SPY	ETF	117.13	117.13	116.75	116.99	39022677.0
2010-03-31 16:00:00	SPY	ETF	116.98	117.373	116.83	117.15	11336933.0
2010-03-31 17:00:00	SPY	ETF	117.16	117.23	117.13	117.2	229249.0
2010-03-31 18:00:00	SPY	ETF	117.19	117.28	117.18	117.28	80461.0
2010-03-31 19:00:00	SPY	ETF	117.28	117.33	117.23	117.3	75258.0
2010-03-31 07:00:00	QQQ	ETF	48.33	48.34	48.33	48.34	3000.0
2010-03-31 08:00:00	QQQ	ETF	48.35	48.39	48.13	48.21	1127263.0
2010-03-31 09:00:00	QQQ	ETF	48.2	48.36	48.1	48.1799	10647126.0
2010-03-31 10:00:00	QQQ	ETF	48.18	48.38	48.16	48.3299	7487001.0
2010-03-31 11:00:00	QQQ	ETF	48.325	48.42	48.25	48.36	7153049.0
2010-03-31 12:00:00	QQQ	ETF	48.365	48.41	48.32	48.34	3158147.0
2010-03-31 13:00:00	QQQ	ETF	48.34	48.4	48.31	48.39	3471454.0
2010-03-31 14:00:00	QQQ	ETF	48.4	48.45	48.2	48.24	7049731.0
2010-03-31 15:00:00	QQQ	ETF	48.24	48.44	48.07	48.18	14225986.0
2010-03-31 16:00:00	QQQ	ETF	48.18	48.349	48.04	48.2	3156405.0
2010-03-31 17:00:00	QQQ	ETF	48.2	48.21	48.1501	48.21	1028132.0
2010-03-31 18:00:00	QQQ	ETF	48.21	48.23	48.18	48.23	72517.0
2010-03-31 19:00:00	QQQ	ETF	48.22	48.25	48.22	48.22	28728.0
2010-03-31 06:00:00	IWM	ETF	68.34	68.34	68.34	68.34	525.0
2010-03-31 07:00:00	IWM	ETF	68.35	68.35	68.35	68.35	1000.0
2010-03-31 08:00:00	IWM	ETF	68.42	68.45	67.97	68.09	388242.0
2010-03-31 09:00:00	IWM	ETF	68.08	68.5099	68.04	68.3	7964604.0
2010-03-31 10:00:00	IWM	ETF	68.3	68.69	68.27	68.58	5937692.0
2010-03-31 11:00:00	IWM	ETF	68.58	68.7401	68.45	68.66	3542281.0
2010-03-31 12:00:00	IWM	ETF	68.66	68.7	68.5	68.55	3416750.0
2010-03-31 13:00:00	IWM	ETF	68.55	68.71	68.48	68.678	3193799.0
2010-03-31 14:00:00	IWM	ETF	68.678	68.81	68.24	68.34	10092117.0
2010-03-31 15:00:00	IWM	ETF	68.34	68.75	67.79	67.8	18503884.0
2010-03-31 16:00:00	IWM	ETF	67.8	68.31	67.75	67.95	4803035.0
2010-03-31 17:00:00	IWM	ETF	67.98	68.03	67.93	67.98	112919.0
2010-03-31 18:00:00	IWM	ETF	68.01	68.01	67.94	68.0	31337.0
2010-03-31 19:00:00	IWM	ETF	68.0	68.0	67.95	68.0	17100.0
2010-03-31 07:00:00	DIA	ETF	109.0	109.0	109.0	109.0	100.0
2010-03-31 08:00:00	DIA	ETF	109.1	109.1	108.67	108.74	25762.0
2010-03-31 09:00:00	DIA	ETF	108.78	108.9199	108.32	108.5402	1015092.0
2010-03-31 10:00:00	DIA	ETF	108.58	109.0	108.51	108.84	1175780.0
2010-03-31 11:00:00	DIA	ETF	108.85	108.97	108.67	108.93	800112.0
2010-03-31 12:00:00	DIA	ETF	108.912	109.0399	108.81	108.91	516433.0
2010-03-31 13:00:00	DIA	ETF	108.92	108.9699	108.83	108.93	186029.0

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

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