PREVIEW / etf_1hour / 2020-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-04.parquet
  size:    371 KB
  rows:    12,773

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-04 04:00:00	SPY	ETF	311.5	311.57	310.95	310.95	44327.0
2020-06-04 05:00:00	SPY	ETF	310.95	311.05	310.31	310.36	63067.0
2020-06-04 06:00:00	SPY	ETF	310.31	310.7	310.26	310.7	141041.0
2020-06-04 07:00:00	SPY	ETF	310.66	311.63	310.42	311.33	1180905.0
2020-06-04 08:00:00	SPY	ETF	310.66	311.75	309.79	310.44	1382531.0
2020-06-04 09:00:00	SPY	ETF	310.44	312.25	310.35	312.09	7719247.0
2020-06-04 10:00:00	SPY	ETF	312.08	313.0	311.89	312.77	10634512.0
2020-06-04 11:00:00	SPY	ETF	312.775	312.89	311.08	311.531	11911762.0
2020-06-04 12:00:00	SPY	ETF	311.53	311.75	310.48	310.5	6957414.0
2020-06-04 13:00:00	SPY	ETF	310.5	311.68	310.39	311.51	6456686.0
2020-06-04 14:00:00	SPY	ETF	311.5	311.6899	310.14	310.15	8005456.0
2020-06-04 15:00:00	SPY	ETF	310.14	311.34	309.08	311.31	17103624.0
2020-06-04 16:00:00	SPY	ETF	311.3	311.95	311.15	311.7	2807794.0
2020-06-04 17:00:00	SPY	ETF	311.73	311.77	311.36	311.6	170118.0
2020-06-04 18:00:00	SPY	ETF	311.63	312.03	311.48	311.7	119253.0
2020-06-04 19:00:00	SPY	ETF	311.75	311.86	311.15	311.2	201136.0
2020-06-04 04:00:00	QQQ	ETF	236.36	236.58	235.96	235.96	11109.0
2020-06-04 05:00:00	QQQ	ETF	235.95	236.11	235.58	235.64	12836.0
2020-06-04 06:00:00	QQQ	ETF	235.59	236.12	235.53	235.93	61877.0
2020-06-04 07:00:00	QQQ	ETF	236.03	236.33	235.76	236.15	176113.0
2020-06-04 08:00:00	QQQ	ETF	235.92	236.38	235.45	235.84	350285.0
2020-06-04 09:00:00	QQQ	ETF	235.8	237.79	235.75	237.36	3566537.0
2020-06-04 10:00:00	QQQ	ETF	237.36	237.77	236.83	237.0	4637929.0
2020-06-04 11:00:00	QQQ	ETF	236.98	237.12	235.26	235.952	6320231.0
2020-06-04 12:00:00	QQQ	ETF	235.97	236.27	234.91	234.96	3875302.0
2020-06-04 13:00:00	QQQ	ETF	234.97	236.09	234.94	235.92	2963430.0
2020-06-04 14:00:00	QQQ	ETF	235.9	236.07	234.23	234.23	3138686.0
2020-06-04 15:00:00	QQQ	ETF	234.235	235.03	233.68	235.0	6972845.0
2020-06-04 16:00:00	QQQ	ETF	235.01	235.5	234.82	235.38	679289.0
2020-06-04 17:00:00	QQQ	ETF	235.38	235.4	235.03	235.22	28907.0
2020-06-04 18:00:00	QQQ	ETF	235.3	235.39	234.92	235.13	45877.0
2020-06-04 19:00:00	QQQ	ETF	235.1	235.24	234.77	234.81	85773.0
2020-06-04 04:00:00	IWM	ETF	143.27	144.0	142.98	143.12	40036.0
2020-06-04 05:00:00	IWM	ETF	143.0	143.1	142.5	142.52	29075.0
2020-06-04 06:00:00	IWM	ETF	142.53	143.04	142.53	142.87	45000.0
2020-06-04 07:00:00	IWM	ETF	142.94	144.36	142.87	144.13	486632.0
2020-06-04 08:00:00	IWM	ETF	144.12	144.51	142.62	143.19	488423.0
2020-06-04 09:00:00	IWM	ETF	143.18	144.4	143.1	144.24	2883221.0
2020-06-04 10:00:00	IWM	ETF	144.25	145.6	144.065	145.51	3629772.0
2020-06-04 11:00:00	IWM	ETF	145.5	145.57	143.665	144.32	4139360.0
2020-06-04 12:00:00	IWM	ETF	144.305	144.52	143.182	143.36	2316951.0
2020-06-04 13:00:00	IWM	ETF	143.37	145.35	143.37	145.305	2563488.0
2020-06-04 14:00:00	IWM	ETF	145.3	145.45	144.45	144.45	2865922.0
2020-06-04 15:00:00	IWM	ETF	144.4413	144.68	143.335	144.62	5188288.0
2020-06-04 16:00:00	IWM	ETF	144.63	145.3	144.5848	145.13	828838.0
2020-06-04 17:00:00	IWM	ETF	145.07	145.1	144.9	145.03	40545.0
2020-06-04 18:00:00	IWM	ETF	145.0	145.25	144.9	145.0	44019.0
2020-06-04 19:00:00	IWM	ETF	145.07	145.07	144.59	144.77	58930.0
2020-06-04 04:00:00	DIA	ETF	262.76	262.76	262.25	262.25	9284.0
2020-06-04 05:00:00	DIA	ETF	262.15	262.15	261.5	261.52	4318.0

> showing 50 of 12,773 rows — these rows as CSV

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