PREVIEW / etf_1hour / 2020-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-27.parquet
  size:    370 KB
  rows:    12,671

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-08-27 04:00:00	SPY	ETF	347.56	347.56	347.22	347.32	32344.0
2020-08-27 05:00:00	SPY	ETF	347.36	347.36	346.93	347.31	13748.0
2020-08-27 06:00:00	SPY	ETF	347.38	347.41	347.27	347.36	72334.0
2020-08-27 07:00:00	SPY	ETF	347.36	347.44	347.16	347.22	394456.0
2020-08-27 08:00:00	SPY	ETF	347.2101	347.97	347.15	347.52	269734.0
2020-08-27 09:00:00	SPY	ETF	347.5	349.5	346.99	349.26	7505299.0
2020-08-27 10:00:00	SPY	ETF	349.26	349.64	347.51	349.5366	8030185.0
2020-08-27 11:00:00	SPY	ETF	349.53	349.9	348.57	349.54	7729029.0
2020-08-27 12:00:00	SPY	ETF	349.54	349.55	346.53	347.02	8152054.0
2020-08-27 13:00:00	SPY	ETF	347.02	348.7	346.62	348.66	5494515.0
2020-08-27 14:00:00	SPY	ETF	348.66	349.51	348.5236	349.12	4949364.0
2020-08-27 15:00:00	SPY	ETF	349.12	349.7	348.17	348.29	11622655.0
2020-08-27 16:00:00	SPY	ETF	348.29	348.9278	348.06	348.83	2874195.0
2020-08-27 17:00:00	SPY	ETF	348.84	348.88	348.74	348.84	58862.0
2020-08-27 18:00:00	SPY	ETF	348.87	349.08	348.76	348.94	91970.0
2020-08-27 19:00:00	SPY	ETF	348.94	349.3	348.88	349.26	66547.0
2020-08-27 04:00:00	QQQ	ETF	292.11	292.11	291.55	291.8	45726.0
2020-08-27 05:00:00	QQQ	ETF	291.71	292.08	291.69	292.02	23745.0
2020-08-27 06:00:00	QQQ	ETF	291.96	292.07	291.84	291.87	57784.0
2020-08-27 07:00:00	QQQ	ETF	291.91	292.17	291.37	291.64	293626.0
2020-08-27 08:00:00	QQQ	ETF	291.91	292.28	291.3802	291.97	330093.0
2020-08-27 09:00:00	QQQ	ETF	291.96	293.65	290.62	292.2	9196497.0
2020-08-27 10:00:00	QQQ	ETF	292.21	293.06	290.38	292.8776	6897069.0
2020-08-27 11:00:00	QQQ	ETF	292.85	293.851	292.4024	293.2	3262122.0
2020-08-27 12:00:00	QQQ	ETF	293.21	293.21	288.705	289.5676	7447472.0
2020-08-27 13:00:00	QQQ	ETF	289.52	291.44	289.0589	291.38	5151428.0
2020-08-27 14:00:00	QQQ	ETF	291.37	292.43	291.18	291.78	3372544.0
2020-08-27 15:00:00	QQQ	ETF	291.79	292.39	290.81	290.99	4985421.0
2020-08-27 16:00:00	QQQ	ETF	290.99	291.7	290.79	291.43	966170.0
2020-08-27 17:00:00	QQQ	ETF	291.45	291.56	291.3	291.4	23157.0
2020-08-27 18:00:00	QQQ	ETF	291.42	291.77	291.38	291.64	54659.0
2020-08-27 19:00:00	QQQ	ETF	291.67	292.04	291.6	291.98	81585.0
2020-08-27 04:00:00	IWM	ETF	155.51	155.51	155.25	155.4	6420.0
2020-08-27 05:00:00	IWM	ETF	155.35	155.4	155.14	155.38	2226.0
2020-08-27 06:00:00	IWM	ETF	155.4	155.5	155.4	155.5	1032.0
2020-08-27 07:00:00	IWM	ETF	155.55	155.55	155.23	155.31	34449.0
2020-08-27 08:00:00	IWM	ETF	155.4899	155.67	155.25	155.43	100742.0
2020-08-27 09:00:00	IWM	ETF	155.48	157.0	155.4	156.835	3850513.0
2020-08-27 10:00:00	IWM	ETF	156.84	156.99	155.395	156.13	2500206.0
2020-08-27 11:00:00	IWM	ETF	156.14	156.32	155.68	156.19	1320261.0
2020-08-27 12:00:00	IWM	ETF	156.19	156.2	154.92	155.08	1944974.0
2020-08-27 13:00:00	IWM	ETF	155.07	155.67	154.6301	155.645	1258551.0
2020-08-27 14:00:00	IWM	ETF	155.63	156.41	155.605	156.205	1254459.0
2020-08-27 15:00:00	IWM	ETF	156.205	156.5	155.76	155.81	2336521.0
2020-08-27 16:00:00	IWM	ETF	155.8	156.33	155.78	156.32	667974.0
2020-08-27 17:00:00	IWM	ETF	156.34	156.34	156.1	156.13	3678.0
2020-08-27 18:00:00	IWM	ETF	156.28	156.4	156.23	156.37	14106.0
2020-08-27 19:00:00	IWM	ETF	156.29	156.48	156.28	156.48	4290.0
2020-08-27 04:00:00	DIA	ETF	283.03	283.03	282.94	282.94	300.0
2020-08-27 06:00:00	DIA	ETF	282.79	282.93	282.78	282.93	2350.0

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

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