PREVIEW / etf_1hour / 2020-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-13.parquet
  size:    378 KB
  rows:    13,145

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
2020-07-13 04:00:00	SPY	ETF	319.0	319.21	318.45	318.83	104462.0
2020-07-13 05:00:00	SPY	ETF	319.0	319.34	318.67	319.34	77607.0
2020-07-13 06:00:00	SPY	ETF	319.28	319.83	319.02	319.78	49740.0
2020-07-13 07:00:00	SPY	ETF	319.74	320.51	319.7	320.25	241350.0
2020-07-13 08:00:00	SPY	ETF	320.29	320.4402	319.1704	320.0	394830.0
2020-07-13 09:00:00	SPY	ETF	320.01	320.44	319.49	319.59	6411193.0
2020-07-13 10:00:00	SPY	ETF	319.6	321.67	319.225	321.65	9070154.0
2020-07-13 11:00:00	SPY	ETF	321.67	322.35	321.45	321.72	8088767.0
2020-07-13 12:00:00	SPY	ETF	321.73	322.03	321.54	321.65	5272018.0
2020-07-13 13:00:00	SPY	ETF	321.66	322.71	321.55	321.92	8385257.0
2020-07-13 14:00:00	SPY	ETF	321.91	322.06	319.07	320.41	13557534.0
2020-07-13 15:00:00	SPY	ETF	320.4	320.51	314.13	314.81	37383038.0
2020-07-13 16:00:00	SPY	ETF	314.82	315.29	314.23	314.96	12246119.0
2020-07-13 17:00:00	SPY	ETF	314.94	315.14	314.67	315.12	259005.0
2020-07-13 18:00:00	SPY	ETF	315.19	316.03	314.84	315.33	228063.0
2020-07-13 19:00:00	SPY	ETF	315.43	316.09	315.42	315.6	218121.0
2020-07-13 04:00:00	QQQ	ETF	265.58	265.72	265.21	265.5	62116.0
2020-07-13 05:00:00	QQQ	ETF	265.7	265.89	265.32	265.84	35870.0
2020-07-13 06:00:00	QQQ	ETF	265.76	266.18	265.7	266.17	31485.0
2020-07-13 07:00:00	QQQ	ETF	266.11	266.93	266.11	266.85	188905.0
2020-07-13 08:00:00	QQQ	ETF	266.6299	267.1	265.47	266.85	236198.0
2020-07-13 09:00:00	QQQ	ETF	266.85	268.3	266.68	267.52	4727321.0
2020-07-13 10:00:00	QQQ	ETF	267.53	269.09	267.0	269.06	4766080.0
2020-07-13 11:00:00	QQQ	ETF	269.07	269.79	268.77	269.17	4067765.0
2020-07-13 12:00:00	QQQ	ETF	269.18	269.37	267.49	267.5233	3736735.0
2020-07-13 13:00:00	QQQ	ETF	267.54	268.74	266.93	267.05	3823360.0
2020-07-13 14:00:00	QQQ	ETF	267.04	267.33	263.0	265.2076	11385972.0
2020-07-13 15:00:00	QQQ	ETF	265.18	265.27	257.69	258.53	18564625.0
2020-07-13 16:00:00	QQQ	ETF	258.53	259.01	257.84	258.63	2802139.0
2020-07-13 17:00:00	QQQ	ETF	258.57	258.75	258.14	258.45	127619.0
2020-07-13 18:00:00	QQQ	ETF	258.49	259.76	258.49	259.44	278746.0
2020-07-13 19:00:00	QQQ	ETF	259.45	260.04	259.43	259.74	141540.0
2020-07-13 04:00:00	IWM	ETF	142.26	142.65	141.7	142.15	13518.0
2020-07-13 05:00:00	IWM	ETF	142.25	142.55	142.04	142.51	6424.0
2020-07-13 06:00:00	IWM	ETF	142.4	142.92	142.37	142.91	24206.0
2020-07-13 07:00:00	IWM	ETF	142.91	143.32	142.85	143.18	80701.0
2020-07-13 08:00:00	IWM	ETF	142.8004	143.23	142.43	142.81	80646.0
2020-07-13 09:00:00	IWM	ETF	142.72	143.11	141.4397	141.445	2219938.0
2020-07-13 10:00:00	IWM	ETF	141.44	142.59	140.915	142.14	3545516.0
2020-07-13 11:00:00	IWM	ETF	142.14	142.88	141.89	142.5	3104635.0
2020-07-13 12:00:00	IWM	ETF	142.51	143.51	142.32	143.51	2364195.0
2020-07-13 13:00:00	IWM	ETF	143.51	144.64	143.375	144.12	5036732.0
2020-07-13 14:00:00	IWM	ETF	144.1	144.456	142.6	143.14	3893553.0
2020-07-13 15:00:00	IWM	ETF	143.145	143.19	139.39	139.52	5808606.0
2020-07-13 16:00:00	IWM	ETF	139.52	139.88	139.25	139.78	935629.0
2020-07-13 17:00:00	IWM	ETF	139.89	139.89	139.66	139.86	9732.0
2020-07-13 18:00:00	IWM	ETF	139.9	140.56	139.9	140.18	57865.0
2020-07-13 19:00:00	IWM	ETF	140.28	140.59	140.25	140.33	10000.0
2020-07-13 04:00:00	DIA	ETF	262.1	262.3	261.97	262.06	2154.0
2020-07-13 05:00:00	DIA	ETF	262.45	262.45	262.45	262.45	100.0

> showing 50 of 13,145 rows — these rows as CSV

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