PREVIEW / etf_1hour / 2020-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-03.parquet
  size:    380 KB
  rows:    13,110

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-06-03 04:00:00	SPY	ETF	309.25	309.41	308.84	309.36	30165.0
2020-06-03 05:00:00	SPY	ETF	309.17	309.81	309.17	309.65	50258.0
2020-06-03 06:00:00	SPY	ETF	309.65	309.68	309.0	309.19	62406.0
2020-06-03 07:00:00	SPY	ETF	309.14	309.69	309.02	309.48	247075.0
2020-06-03 08:00:00	SPY	ETF	309.2145	310.18	308.75	309.9599	896847.0
2020-06-03 09:00:00	SPY	ETF	309.94	310.86	309.85	310.57	11279774.0
2020-06-03 10:00:00	SPY	ETF	310.58	311.36	310.45	311.01	10498324.0
2020-06-03 11:00:00	SPY	ETF	311.01	312.06	310.97	311.72	9582685.0
2020-06-03 12:00:00	SPY	ETF	311.72	311.74	311.19	311.215	7573650.0
2020-06-03 13:00:00	SPY	ETF	311.23	311.67	311.13	311.36	5780162.0
2020-06-03 14:00:00	SPY	ETF	311.36	312.38	311.3	312.13	10088989.0
2020-06-03 15:00:00	SPY	ETF	312.13	313.22	311.93	312.2117	25041335.0
2020-06-03 16:00:00	SPY	ETF	312.22	312.2854	311.86	312.1	9160229.0
2020-06-03 17:00:00	SPY	ETF	312.03	312.28	312.03	312.12	591400.0
2020-06-03 18:00:00	SPY	ETF	312.12	312.2853	311.55	312.02	346780.0
2020-06-03 19:00:00	SPY	ETF	312.03	312.95	312.03	312.65	468791.0
2020-06-03 04:00:00	QQQ	ETF	236.25	236.35	235.94	236.26	16960.0
2020-06-03 05:00:00	QQQ	ETF	236.2	236.6	236.2	236.49	24773.0
2020-06-03 06:00:00	QQQ	ETF	236.41	236.41	235.99	236.35	24707.0
2020-06-03 07:00:00	QQQ	ETF	236.11	236.43	235.96	236.3	167229.0
2020-06-03 08:00:00	QQQ	ETF	236.1801	236.6	235.54	235.82	354231.0
2020-06-03 09:00:00	QQQ	ETF	235.88	236.73	235.56	236.69	4597963.0
2020-06-03 10:00:00	QQQ	ETF	236.7	236.85	235.81	236.25	4454726.0
2020-06-03 11:00:00	QQQ	ETF	236.23	236.65	235.835	236.1601	3315674.0
2020-06-03 12:00:00	QQQ	ETF	236.16	236.19	235.35	235.8611	6661312.0
2020-06-03 13:00:00	QQQ	ETF	235.87	236.4	235.78	236.1721	1991474.0
2020-06-03 14:00:00	QQQ	ETF	236.18	236.92	236.11	236.745	2763922.0
2020-06-03 15:00:00	QQQ	ETF	236.74	237.47	236.51	236.68	5660324.0
2020-06-03 16:00:00	QQQ	ETF	236.67	236.7726	236.29	236.51	702995.0
2020-06-03 17:00:00	QQQ	ETF	236.59	236.59	236.3	236.44	34886.0
2020-06-03 18:00:00	QQQ	ETF	236.44	236.77	236.0	236.33	423191.0
2020-06-03 19:00:00	QQQ	ETF	236.33	236.92	236.33	236.74	90337.0
2020-06-03 04:00:00	IWM	ETF	142.36	142.43	142.04	142.43	11425.0
2020-06-03 05:00:00	IWM	ETF	142.31	142.95	142.27	142.72	15875.0
2020-06-03 06:00:00	IWM	ETF	142.6	142.79	142.25	142.57	77915.0
2020-06-03 07:00:00	IWM	ETF	142.59	142.62	142.07	142.55	39714.0
2020-06-03 08:00:00	IWM	ETF	142.5096	143.64	142.1496	143.25	309879.0
2020-06-03 09:00:00	IWM	ETF	143.28	144.25	143.11	144.02	3763646.0
2020-06-03 10:00:00	IWM	ETF	144.01	144.96	143.97	144.7	5246218.0
2020-06-03 11:00:00	IWM	ETF	144.69	146.07	144.53	145.66	5845514.0
2020-06-03 12:00:00	IWM	ETF	145.66	145.78	145.015	145.155	3084157.0
2020-06-03 13:00:00	IWM	ETF	145.16	145.495	144.85	145.125	1764962.0
2020-06-03 14:00:00	IWM	ETF	145.125	145.66	145.075	145.19	2635557.0
2020-06-03 15:00:00	IWM	ETF	145.19	145.4	144.52	144.73	6404834.0
2020-06-03 16:00:00	IWM	ETF	144.74	144.8	144.37	144.68	1934756.0
2020-06-03 17:00:00	IWM	ETF	144.66	144.79	144.66	144.69	20351.0
2020-06-03 18:00:00	IWM	ETF	144.67	144.94	144.47	144.89	315097.0
2020-06-03 19:00:00	IWM	ETF	144.94	145.65	144.94	145.35	58041.0
2020-06-03 04:00:00	DIA	ETF	259.21	259.21	259.04	259.17	1700.0
2020-06-03 05:00:00	DIA	ETF	259.74	259.9	259.73	259.79	7611.0

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

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