PREVIEW / etf_1hour / 2020-10-12

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-12.parquet
  size:    379 KB
  rows:    12,818

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-10-12 04:00:00	SPY	ETF	347.97	349.09	347.96	348.13	56689.0
2020-10-12 05:00:00	SPY	ETF	348.12	348.52	348.05	348.16	72960.0
2020-10-12 06:00:00	SPY	ETF	348.11	348.92	348.11	348.9	31864.0
2020-10-12 07:00:00	SPY	ETF	348.9	349.19	348.63	349.13	295044.0
2020-10-12 08:00:00	SPY	ETF	349.11	349.87	347.94	349.55	732885.0
2020-10-12 09:00:00	SPY	ETF	349.53	349.82	349.06	349.41	4457294.0
2020-10-12 10:00:00	SPY	ETF	349.4282	350.94	349.24	350.71	7108822.0
2020-10-12 11:00:00	SPY	ETF	350.735	352.11	350.735	351.72	7372525.0
2020-10-12 12:00:00	SPY	ETF	351.72	353.31	351.66	352.83	7209260.0
2020-10-12 13:00:00	SPY	ETF	352.84	353.79	352.56	353.31	7367589.0
2020-10-12 14:00:00	SPY	ETF	353.305	354.02	353.28	353.51	7884873.0
2020-10-12 15:00:00	SPY	ETF	353.5101	353.76	352.13	352.43	21044718.0
2020-10-12 16:00:00	SPY	ETF	352.4	353.3	346.7752	353.05	10212797.0
2020-10-12 17:00:00	SPY	ETF	352.95	353.24	352.43	353.24	4282481.0
2020-10-12 18:00:00	SPY	ETF	353.13	353.3901	352.9	352.91	106134.0
2020-10-12 19:00:00	SPY	ETF	352.96	353.2	352.8	353.04	68013.0
2020-10-12 04:00:00	QQQ	ETF	287.76	289.77	287.7	289.0	70750.0
2020-10-12 05:00:00	QQQ	ETF	289.02	289.33	288.61	288.81	18678.0
2020-10-12 06:00:00	QQQ	ETF	288.7	290.05	288.7	290.0	29575.0
2020-10-12 07:00:00	QQQ	ETF	289.95	290.9	289.75	290.8	294712.0
2020-10-12 08:00:00	QQQ	ETF	290.79	291.61	287.19	291.03	853337.0
2020-10-12 09:00:00	QQQ	ETF	291.02	291.36	289.47	289.9799	5165161.0
2020-10-12 10:00:00	QQQ	ETF	289.96	291.975	289.5	291.86	5573059.0
2020-10-12 11:00:00	QQQ	ETF	291.88	293.63	291.87	293.05	8566800.0
2020-10-12 12:00:00	QQQ	ETF	293.07	295.875	293.0122	295.08	8266963.0
2020-10-12 13:00:00	QQQ	ETF	295.08	296.3	294.532	295.875	7104831.0
2020-10-12 14:00:00	QQQ	ETF	295.88	297.46	295.85	296.14	9478893.0
2020-10-12 15:00:00	QQQ	ETF	296.15	296.59	294.15	294.52	11249371.0
2020-10-12 16:00:00	QQQ	ETF	294.5	295.36	289.78	294.85	2587010.0
2020-10-12 17:00:00	QQQ	ETF	294.81	295.1	294.79	295.1	34334.0
2020-10-12 18:00:00	QQQ	ETF	295.18	295.6	295.0	295.08	108149.0
2020-10-12 19:00:00	QQQ	ETF	295.13	295.47	295.13	295.35	88394.0
2020-10-12 04:00:00	IWM	ETF	163.01	163.37	162.5	162.5	15904.0
2020-10-12 05:00:00	IWM	ETF	162.53	162.8	162.5	162.56	26479.0
2020-10-12 06:00:00	IWM	ETF	162.58	162.93	162.56	162.92	13850.0
2020-10-12 07:00:00	IWM	ETF	162.9	163.02	162.77	162.94	41748.0
2020-10-12 08:00:00	IWM	ETF	162.93	163.53	162.8099	163.34	112094.0
2020-10-12 09:00:00	IWM	ETF	163.29	163.46	162.6	163.23	2233256.0
2020-10-12 10:00:00	IWM	ETF	163.23	163.89	163.15	163.39	2138767.0
2020-10-12 11:00:00	IWM	ETF	163.44	164.115	163.43	163.58	2322666.0
2020-10-12 12:00:00	IWM	ETF	163.58	163.7601	163.32	163.355	1681680.0
2020-10-12 13:00:00	IWM	ETF	163.35	163.51	163.07	163.27	1234631.0
2020-10-12 14:00:00	IWM	ETF	163.275	163.68	162.9178	163.66	1536230.0
2020-10-12 15:00:00	IWM	ETF	163.67	164.24	163.67	163.81	4774243.0
2020-10-12 16:00:00	IWM	ETF	163.79	164.33	163.72	164.13	920305.0
2020-10-12 17:00:00	IWM	ETF	164.09	164.22	164.09	164.22	5684.0
2020-10-12 18:00:00	IWM	ETF	164.15	164.19	163.91	163.95	49006.0
2020-10-12 19:00:00	IWM	ETF	163.98	164.07	163.9	163.97	11988.0
2020-10-12 04:00:00	DIA	ETF	286.45	287.03	286.01	286.01	13069.0
2020-10-12 05:00:00	DIA	ETF	286.09	286.45	286.09	286.29	3475.0

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

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