PREVIEW / etf_1hour / 2020-10-16

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-16.parquet
  size:    363 KB
  rows:    12,310

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-16 04:00:00	SPY	ETF	347.55	347.82	347.37	347.79	42195.0
2020-10-16 05:00:00	SPY	ETF	347.81	347.81	347.03	347.53	19174.0
2020-10-16 06:00:00	SPY	ETF	347.46	348.28	347.34	348.0	165770.0
2020-10-16 07:00:00	SPY	ETF	348.02	348.6	347.78	348.23	186033.0
2020-10-16 08:00:00	SPY	ETF	347.7699	349.0	347.0	348.98	452299.0
2020-10-16 09:00:00	SPY	ETF	348.96	349.2	348.27	349.13	5829084.0
2020-10-16 10:00:00	SPY	ETF	349.13	350.75	349.07	349.89	16975713.0
2020-10-16 11:00:00	SPY	ETF	349.88	349.89	348.56	349.44	8677120.0
2020-10-16 12:00:00	SPY	ETF	349.43	349.48	348.36	349.001	5503601.0
2020-10-16 13:00:00	SPY	ETF	349.01	349.56	348.84	349.25	4555244.0
2020-10-16 14:00:00	SPY	ETF	349.27	349.92	348.95	349.89	6787374.0
2020-10-16 15:00:00	SPY	ETF	349.88	349.91	347.1	347.24	16376148.0
2020-10-16 16:00:00	SPY	ETF	347.24	347.4833	346.06	346.39	21879216.0
2020-10-16 17:00:00	SPY	ETF	346.4	347.29	346.06	346.27	1031016.0
2020-10-16 18:00:00	SPY	ETF	346.28	346.48	346.2	346.45	74167.0
2020-10-16 19:00:00	SPY	ETF	346.41	346.48	346.21	346.21	60078.0
2020-10-16 04:00:00	QQQ	ETF	290.1	290.97	290.1	290.56	52139.0
2020-10-16 05:00:00	QQQ	ETF	290.45	290.61	289.62	290.1	44911.0
2020-10-16 06:00:00	QQQ	ETF	290.17	290.87	289.67	290.17	60133.0
2020-10-16 07:00:00	QQQ	ETF	290.14	291.38	289.97	290.97	218797.0
2020-10-16 08:00:00	QQQ	ETF	290.25	292.0	288.9	291.98	238725.0
2020-10-16 09:00:00	QQQ	ETF	291.96	292.12	290.9501	291.795	3748806.0
2020-10-16 10:00:00	QQQ	ETF	291.8	293.269	291.63	291.95	4902829.0
2020-10-16 11:00:00	QQQ	ETF	291.95	291.95	289.68	290.98	5344579.0
2020-10-16 12:00:00	QQQ	ETF	290.96	291.16	289.78	290.76	3419062.0
2020-10-16 13:00:00	QQQ	ETF	290.75	291.438	290.62	290.9499	2194272.0
2020-10-16 14:00:00	QQQ	ETF	290.97	291.79	290.581	291.62	2846382.0
2020-10-16 15:00:00	QQQ	ETF	291.6211	291.705	288.15	288.45	6094710.0
2020-10-16 16:00:00	QQQ	ETF	288.46	293.0	287.65	287.77	2340894.0
2020-10-16 17:00:00	QQQ	ETF	287.75	288.51	287.75	287.97	697284.0
2020-10-16 18:00:00	QQQ	ETF	287.97	288.05	287.95	287.96	30140.0
2020-10-16 19:00:00	QQQ	ETF	287.96	288.1	287.61	287.61	18516.0
2020-10-16 04:00:00	IWM	ETF	163.19	163.24	162.85	163.02	13018.0
2020-10-16 05:00:00	IWM	ETF	163.02	163.14	162.73	163.0	8362.0
2020-10-16 06:00:00	IWM	ETF	162.97	163.34	162.9	163.25	119553.0
2020-10-16 07:00:00	IWM	ETF	163.18	163.3	163.09	163.14	128290.0
2020-10-16 08:00:00	IWM	ETF	163.1	163.47	162.93	163.38	113831.0
2020-10-16 09:00:00	IWM	ETF	163.34	163.43	162.38	162.695	2205875.0
2020-10-16 10:00:00	IWM	ETF	162.7	163.54	162.49	163.24	2694047.0
2020-10-16 11:00:00	IWM	ETF	163.25	163.7	162.81	163.68	1724514.0
2020-10-16 12:00:00	IWM	ETF	163.67	163.67	162.61	163.03	1322048.0
2020-10-16 13:00:00	IWM	ETF	163.02	163.51	163.0122	163.37	607785.0
2020-10-16 14:00:00	IWM	ETF	163.375	163.52	163.1	163.37	951678.0
2020-10-16 15:00:00	IWM	ETF	163.37	163.37	162.31	162.36	3129742.0
2020-10-16 16:00:00	IWM	ETF	162.35	162.38	161.79	162.02	1289357.0
2020-10-16 17:00:00	IWM	ETF	161.92	162.35	161.91	162.07	234257.0
2020-10-16 18:00:00	IWM	ETF	162.1	162.1	161.98	162.0	6792.0
2020-10-16 19:00:00	IWM	ETF	162.1	162.26	162.05	162.05	1629.0
2020-10-16 04:00:00	DIA	ETF	284.76	284.76	284.76	284.76	700.0
2020-10-16 06:00:00	DIA	ETF	284.9	285.16	284.9	285.16	2200.0

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

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