PREVIEW / etf_1hour / 2020-02-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-02-10.parquet
  size:    358 KB
  rows:    11,833

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-02-10 04:00:00	SPY	ETF	331.77	332.44	331.75	331.82	43304.0
2020-02-10 05:00:00	SPY	ETF	331.67	332.5	331.59	332.24	63834.0
2020-02-10 06:00:00	SPY	ETF	332.23	332.41	332.18	332.18	18017.0
2020-02-10 07:00:00	SPY	ETF	332.23	332.4	331.9	331.99	179841.0
2020-02-10 08:00:00	SPY	ETF	331.98	332.44	331.5	331.65	336533.0
2020-02-10 09:00:00	SPY	ETF	331.67	332.79	331.06	332.78	5865089.0
2020-02-10 10:00:00	SPY	ETF	332.7891	333.7	332.74	333.325	5673147.0
2020-02-10 11:00:00	SPY	ETF	333.32	333.7082	333.13	333.38	4636197.0
2020-02-10 12:00:00	SPY	ETF	333.37	333.38	332.88	333.05	3061904.0
2020-02-10 13:00:00	SPY	ETF	333.05	333.3693	333.0	333.19	2892765.0
2020-02-10 14:00:00	SPY	ETF	333.195	333.82	333.015	333.8	2782589.0
2020-02-10 15:00:00	SPY	ETF	333.8	334.72	333.77	334.69	9622872.0
2020-02-10 16:00:00	SPY	ETF	334.7	334.89	334.3484	334.78	5250808.0
2020-02-10 17:00:00	SPY	ETF	334.82	334.82	334.68	334.7	112362.0
2020-02-10 18:00:00	SPY	ETF	334.7	334.82	334.52	334.7	82705.0
2020-02-10 19:00:00	SPY	ETF	334.69	335.31	334.52	335.13	204079.0
2020-02-10 04:00:00	QQQ	ETF	228.89	229.41	228.89	229.01	23529.0
2020-02-10 05:00:00	QQQ	ETF	229.06	229.62	228.83	229.41	76806.0
2020-02-10 06:00:00	QQQ	ETF	229.38	229.59	229.37	229.4	14493.0
2020-02-10 07:00:00	QQQ	ETF	229.45	229.57	229.11	229.18	121161.0
2020-02-10 08:00:00	QQQ	ETF	229.47	229.7	228.63	228.91	310196.0
2020-02-10 09:00:00	QQQ	ETF	228.9	230.09	228.38	230.08	4152143.0
2020-02-10 10:00:00	QQQ	ETF	230.074	230.818	229.99	230.3271	2669314.0
2020-02-10 11:00:00	QQQ	ETF	230.36	230.98	230.23	230.77	1650333.0
2020-02-10 12:00:00	QQQ	ETF	230.75	230.77	230.28	230.5	990580.0
2020-02-10 13:00:00	QQQ	ETF	230.51	230.82	230.4684	230.65	754749.0
2020-02-10 14:00:00	QQQ	ETF	230.6573	231.19	230.51	231.15	1300026.0
2020-02-10 15:00:00	QQQ	ETF	231.1566	231.98	231.13	231.96	3436836.0
2020-02-10 16:00:00	QQQ	ETF	231.96	232.1	231.75	231.96	628412.0
2020-02-10 17:00:00	QQQ	ETF	231.95	232.0	231.88	231.96	104497.0
2020-02-10 18:00:00	QQQ	ETF	231.9	232.02	231.78	231.97	34717.0
2020-02-10 19:00:00	QQQ	ETF	231.95	232.55	231.82	232.39	83511.0
2020-02-10 04:00:00	IWM	ETF	164.7	164.9	164.7	164.85	2500.0
2020-02-10 05:00:00	IWM	ETF	164.73	165.05	164.72	164.95	6100.0
2020-02-10 07:00:00	IWM	ETF	164.95	165.04	164.83	165.04	16800.0
2020-02-10 08:00:00	IWM	ETF	164.67	164.95	164.66	164.67	23475.0
2020-02-10 09:00:00	IWM	ETF	164.64	165.15	164.46	165.15	1514645.0
2020-02-10 10:00:00	IWM	ETF	165.15	165.29	164.89	165.195	1458959.0
2020-02-10 11:00:00	IWM	ETF	165.195	165.45	165.15	165.18	1421085.0
2020-02-10 12:00:00	IWM	ETF	165.17	165.32	165.04	165.17	702896.0
2020-02-10 13:00:00	IWM	ETF	165.17	165.33	165.12	165.2	643368.0
2020-02-10 14:00:00	IWM	ETF	165.19	165.5	165.13	165.45	700424.0
2020-02-10 15:00:00	IWM	ETF	165.45	165.89	165.435	165.86	2130615.0
2020-02-10 16:00:00	IWM	ETF	165.87	166.06	165.79	165.93	812799.0
2020-02-10 17:00:00	IWM	ETF	165.81	165.99	165.81	165.98	107088.0
2020-02-10 18:00:00	IWM	ETF	165.92	166.0	165.9	165.94	20300.0
2020-02-10 19:00:00	IWM	ETF	165.9	166.26	165.9	166.19	10125.0
2020-02-10 04:00:00	DIA	ETF	291.08	291.49	290.88	290.88	965.0
2020-02-10 05:00:00	DIA	ETF	290.6	291.5	290.5	291.5	2648.0
2020-02-10 07:00:00	DIA	ETF	291.05	291.11	290.9	290.9	7098.0

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

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