PREVIEW / etf_1hour / 2010-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-01.parquet
  size:    167 KB
  rows:    5,108

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-10-01 04:00:00	SPY	ETF	114.52	114.71	114.52	114.66	3334.0
2010-10-01 05:00:00	SPY	ETF	114.7	114.8	114.7	114.73	2200.0
2010-10-01 06:00:00	SPY	ETF	114.83	114.85	114.44	114.44	86263.0
2010-10-01 07:00:00	SPY	ETF	114.43	114.77	114.27	114.75	1212167.0
2010-10-01 08:00:00	SPY	ETF	114.75	114.9	114.12	114.85	3258449.0
2010-10-01 09:00:00	SPY	ETF	114.86	115.12	114.13	114.868	22768429.0
2010-10-01 10:00:00	SPY	ETF	114.86	115.03	113.93	114.29	57690981.0
2010-10-01 11:00:00	SPY	ETF	114.29	114.58	114.06	114.47	22526207.0
2010-10-01 12:00:00	SPY	ETF	114.47	114.54	114.24	114.4	8337708.0
2010-10-01 13:00:00	SPY	ETF	114.4	114.69	114.3	114.5	10937301.0
2010-10-01 14:00:00	SPY	ETF	114.49	114.79	114.49	114.71	12906130.0
2010-10-01 15:00:00	SPY	ETF	114.71	114.85	114.48	114.6299	25434729.0
2010-10-01 16:00:00	SPY	ETF	114.62	115.08	114.175	114.82	6265060.0
2010-10-01 17:00:00	SPY	ETF	114.83	114.85	114.72	114.76	290864.0
2010-10-01 18:00:00	SPY	ETF	114.76	114.8	114.61	114.78	21508.0
2010-10-01 19:00:00	SPY	ETF	114.78	114.84	114.72	114.84	60692.0
2010-10-01 04:00:00	QQQ	ETF	49.29	49.31	49.29	49.31	1000.0
2010-10-01 05:00:00	QQQ	ETF	49.4	49.4	49.4	49.4	600.0
2010-10-01 06:00:00	QQQ	ETF	49.31	49.31	49.24	49.25	3426.0
2010-10-01 07:00:00	QQQ	ETF	49.23	49.38	49.18	49.38	95802.0
2010-10-01 08:00:00	QQQ	ETF	49.38	49.46	49.28	49.43	1794126.0
2010-10-01 09:00:00	QQQ	ETF	49.41	49.53	49.31	49.425	11823878.0
2010-10-01 10:00:00	QQQ	ETF	49.42	49.4998	48.781	48.94	22178046.0
2010-10-01 11:00:00	QQQ	ETF	48.935	49.11	48.84	49.05	9663814.0
2010-10-01 12:00:00	QQQ	ETF	49.05	49.0695	48.92	49.02	3039838.0
2010-10-01 13:00:00	QQQ	ETF	49.03	49.12	48.91	48.98	4863452.0
2010-10-01 14:00:00	QQQ	ETF	48.99	49.12	48.99	49.05	4348263.0
2010-10-01 15:00:00	QQQ	ETF	49.06	49.1681	49.0	49.02	9838191.0
2010-10-01 16:00:00	QQQ	ETF	49.02	49.1023	48.96	49.04	4141157.0
2010-10-01 17:00:00	QQQ	ETF	49.05	49.06	49.03	49.03	12613.0
2010-10-01 18:00:00	QQQ	ETF	49.04	49.04	49.03	49.04	1600.0
2010-10-01 19:00:00	QQQ	ETF	49.05	49.09	49.05	49.09	5395.0
2010-10-01 04:00:00	IWM	ETF	67.91	67.91	67.91	67.91	100.0
2010-10-01 05:00:00	IWM	ETF	67.93	68.08	67.93	68.08	200.0
2010-10-01 06:00:00	IWM	ETF	67.96	67.99	67.96	67.99	1800.0
2010-10-01 07:00:00	IWM	ETF	67.7	68.0	67.63	68.0	37950.0
2010-10-01 08:00:00	IWM	ETF	67.99	68.13	67.47	68.08	304577.0
2010-10-01 09:00:00	IWM	ETF	68.08	68.26	67.5	68.02	7312351.0
2010-10-01 10:00:00	IWM	ETF	68.03	68.16	67.27	67.42	13262271.0
2010-10-01 11:00:00	IWM	ETF	67.41	67.82	67.25	67.7102	8894602.0
2010-10-01 12:00:00	IWM	ETF	67.72	67.7501	67.41	67.56	3214472.0
2010-10-01 13:00:00	IWM	ETF	67.57	67.83	67.47	67.63	4413980.0
2010-10-01 14:00:00	IWM	ETF	67.63	67.96	67.63	67.93	3793528.0
2010-10-01 15:00:00	IWM	ETF	67.93	68.08	67.76	67.87	11578921.0
2010-10-01 16:00:00	IWM	ETF	67.86	68.01	67.82	67.96	5499437.0
2010-10-01 17:00:00	IWM	ETF	67.98	67.98	67.95	67.95	4383.0
2010-10-01 18:00:00	IWM	ETF	68.03	68.03	67.96	68.0	648.0
2010-10-01 19:00:00	IWM	ETF	68.02	68.02	67.9	67.92	1500.0
2010-10-01 07:00:00	DIA	ETF	108.1	108.38	108.1	108.38	13600.0
2010-10-01 08:00:00	DIA	ETF	108.37	108.48	108.32	108.47	14820.0

> showing 50 of 5,108 rows — these rows as CSV

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