PREVIEW / etf_1hour / 2020-01-22

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-22.parquet
  size:    360 KB
  rows:    11,771

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-01-22 04:00:00	SPY	ETF	332.32	332.45	332.13	332.32	147232.0
2020-01-22 05:00:00	SPY	ETF	332.3	332.45	332.29	332.39	16800.0
2020-01-22 06:00:00	SPY	ETF	332.39	332.52	332.25	332.45	36493.0
2020-01-22 07:00:00	SPY	ETF	332.44	332.66	332.4	332.42	89424.0
2020-01-22 08:00:00	SPY	ETF	332.43	332.7	332.24	332.36	218201.0
2020-01-22 09:00:00	SPY	ETF	332.35	332.77	332.0	332.66	5943043.0
2020-01-22 10:00:00	SPY	ETF	332.66	332.95	332.28	332.36	8531645.0
2020-01-22 11:00:00	SPY	ETF	332.36	332.3979	331.84	332.04	8330861.0
2020-01-22 12:00:00	SPY	ETF	332.035	332.18	331.65	332.16	3160874.0
2020-01-22 13:00:00	SPY	ETF	332.15	332.4	332.05	332.06	2865393.0
2020-01-22 14:00:00	SPY	ETF	332.055	332.275	331.925	332.045	4534408.0
2020-01-22 15:00:00	SPY	ETF	332.04	332.05	331.17	331.39	9832357.0
2020-01-22 16:00:00	SPY	ETF	331.39	331.9864	330.8	330.98	4045402.0
2020-01-22 17:00:00	SPY	ETF	330.98	331.34	330.9	331.0	156337.0
2020-01-22 18:00:00	SPY	ETF	330.98	331.13	330.65	330.72	143652.0
2020-01-22 19:00:00	SPY	ETF	330.73	331.06	330.51	331.0	64646.0
2020-01-22 04:00:00	QQQ	ETF	224.25	224.53	224.25	224.43	28942.0
2020-01-22 05:00:00	QQQ	ETF	224.42	224.57	224.39	224.5	13650.0
2020-01-22 06:00:00	QQQ	ETF	224.49	224.63	224.43	224.62	21002.0
2020-01-22 07:00:00	QQQ	ETF	224.61	224.78	224.59	224.62	77203.0
2020-01-22 08:00:00	QQQ	ETF	224.63	224.75	224.42	224.46	224499.0
2020-01-22 09:00:00	QQQ	ETF	224.43	224.9	224.11	224.8	2722014.0
2020-01-22 10:00:00	QQQ	ETF	224.8001	225.15	224.45	224.745	2542094.0
2020-01-22 11:00:00	QQQ	ETF	224.74	224.84	224.299	224.6	2057261.0
2020-01-22 12:00:00	QQQ	ETF	224.6	224.83	224.32	224.81	1430344.0
2020-01-22 13:00:00	QQQ	ETF	224.83	224.97	224.52	224.53	1501562.0
2020-01-22 14:00:00	QQQ	ETF	224.5348	224.735	224.4	224.53	1193376.0
2020-01-22 15:00:00	QQQ	ETF	224.52	224.53	223.59	223.86	3617829.0
2020-01-22 16:00:00	QQQ	ETF	223.86	223.98	223.39	223.55	980845.0
2020-01-22 17:00:00	QQQ	ETF	223.62	223.69	223.47	223.69	12968.0
2020-01-22 18:00:00	QQQ	ETF	223.6	223.75	223.34	223.42	33089.0
2020-01-22 19:00:00	QQQ	ETF	223.46	223.71	223.35	223.65	36785.0
2020-01-22 04:00:00	IWM	ETF	168.22	168.32	168.13	168.13	10000.0
2020-01-22 05:00:00	IWM	ETF	168.11	168.21	168.1	168.17	3400.0
2020-01-22 06:00:00	IWM	ETF	168.14	168.37	168.06	168.22	13890.0
2020-01-22 07:00:00	IWM	ETF	168.22	168.39	168.2	168.36	50128.0
2020-01-22 08:00:00	IWM	ETF	168.2198	168.39	168.2198	168.34	79688.0
2020-01-22 09:00:00	IWM	ETF	168.33	168.62	168.03	168.19	1182848.0
2020-01-22 10:00:00	IWM	ETF	168.21	168.43	167.84	167.87	1304764.0
2020-01-22 11:00:00	IWM	ETF	167.86	167.95	167.6	167.815	1375487.0
2020-01-22 12:00:00	IWM	ETF	167.82	167.89	167.47	167.8	1152888.0
2020-01-22 13:00:00	IWM	ETF	167.805	168.005	167.74	167.91	1069836.0
2020-01-22 14:00:00	IWM	ETF	167.9	168.06	167.87	167.96	984415.0
2020-01-22 15:00:00	IWM	ETF	167.96	167.96	167.18	167.52	3360452.0
2020-01-22 16:00:00	IWM	ETF	167.5	167.57	167.14	167.17	1429662.0
2020-01-22 17:00:00	IWM	ETF	167.26	167.3	167.26	167.29	4474.0
2020-01-22 18:00:00	IWM	ETF	167.25	167.28	167.0	167.16	8710.0
2020-01-22 19:00:00	IWM	ETF	167.34	167.34	167.11	167.32	10600.0
2020-01-22 04:00:00	DIA	ETF	292.93	292.93	292.93	292.93	200.0
2020-01-22 05:00:00	DIA	ETF	292.98	292.98	292.97	292.97	322.0

> showing 50 of 11,771 rows — these rows as CSV

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