PREVIEW / etf_1hour / 2020-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-21.parquet
  size:    367 KB
  rows:    12,530

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-21 04:00:00	SPY	ETF	343.93	343.97	342.22	342.24	72289.0
2020-10-21 05:00:00	SPY	ETF	342.23	343.75	342.05	343.54	66823.0
2020-10-21 06:00:00	SPY	ETF	343.64	343.7	343.09	343.38	46872.0
2020-10-21 07:00:00	SPY	ETF	343.35	343.35	342.31	342.85	130404.0
2020-10-21 08:00:00	SPY	ETF	342.92	345.33	342.52	343.432	442342.0
2020-10-21 09:00:00	SPY	ETF	343.41	345.5319	343.11	345.39	4897446.0
2020-10-21 10:00:00	SPY	ETF	345.405	345.67	343.8546	344.05	5660755.0
2020-10-21 11:00:00	SPY	ETF	344.05	344.13	342.4	343.133	8310793.0
2020-10-21 12:00:00	SPY	ETF	343.16	345.1	342.45	342.775	10150912.0
2020-10-21 13:00:00	SPY	ETF	342.77	344.2	342.63	343.53	5988386.0
2020-10-21 14:00:00	SPY	ETF	343.53	344.94	343.33	344.91	5651717.0
2020-10-21 15:00:00	SPY	ETF	344.92	345.02	342.61	342.69	14906479.0
2020-10-21 16:00:00	SPY	ETF	342.65	343.77	342.61	343.07	5645418.0
2020-10-21 17:00:00	SPY	ETF	343.09	343.29	342.5	342.99	289437.0
2020-10-21 18:00:00	SPY	ETF	342.85	343.3	342.69	342.73	204013.0
2020-10-21 19:00:00	SPY	ETF	342.79	343.14	340.28	341.34	407356.0
2020-10-21 04:00:00	QQQ	ETF	284.7	284.95	283.12	283.12	76518.0
2020-10-21 05:00:00	QQQ	ETF	283.07	285.04	282.73	284.68	89337.0
2020-10-21 06:00:00	QQQ	ETF	284.88	285.13	284.3	284.8	47190.0
2020-10-21 07:00:00	QQQ	ETF	284.82	284.83	283.43	283.63	132824.0
2020-10-21 08:00:00	QQQ	ETF	284.17	286.32	283.45	284.78	185517.0
2020-10-21 09:00:00	QQQ	ETF	284.79	287.32	284.34	287.19	2710161.0
2020-10-21 10:00:00	QQQ	ETF	287.19	287.3199	285.22	285.44	3728146.0
2020-10-21 11:00:00	QQQ	ETF	285.44	285.66	283.69	284.49	3573417.0
2020-10-21 12:00:00	QQQ	ETF	284.525	286.31	283.76	284.01	3821630.0
2020-10-21 13:00:00	QQQ	ETF	283.99	285.74	283.81	285.07	2273723.0
2020-10-21 14:00:00	QQQ	ETF	285.1	286.6299	284.79	286.59	2429870.0
2020-10-21 15:00:00	QQQ	ETF	286.61	286.65	284.16	284.19	4732088.0
2020-10-21 16:00:00	QQQ	ETF	284.2	285.53	284.15	285.0	1969394.0
2020-10-21 17:00:00	QQQ	ETF	285.09	285.18	284.77	284.9	64165.0
2020-10-21 18:00:00	QQQ	ETF	284.79	285.38	284.47	284.9	89250.0
2020-10-21 19:00:00	QQQ	ETF	284.97	285.15	282.82	283.6	264136.0
2020-10-21 04:00:00	IWM	ETF	160.93	161.03	160.3	160.3	8689.0
2020-10-21 05:00:00	IWM	ETF	160.39	160.87	160.39	160.87	3020.0
2020-10-21 06:00:00	IWM	ETF	160.86	160.94	160.76	160.78	2524.0
2020-10-21 07:00:00	IWM	ETF	160.67	160.67	160.25	160.52	119616.0
2020-10-21 08:00:00	IWM	ETF	160.3501	161.75	160.35	160.66	149409.0
2020-10-21 09:00:00	IWM	ETF	160.62	161.365	160.62	160.94	1500626.0
2020-10-21 10:00:00	IWM	ETF	160.945	161.36	160.1	160.1769	1832728.0
2020-10-21 11:00:00	IWM	ETF	160.18	160.339	159.52	159.68	2217595.0
2020-10-21 12:00:00	IWM	ETF	159.73	160.79	159.49	159.67	2865686.0
2020-10-21 13:00:00	IWM	ETF	159.67	160.23	159.6	159.89	1535088.0
2020-10-21 14:00:00	IWM	ETF	159.91	160.48	159.84	160.44	1494869.0
2020-10-21 15:00:00	IWM	ETF	160.46	160.49	159.29	159.32	2859091.0
2020-10-21 16:00:00	IWM	ETF	159.38	159.9	159.2	159.65	779408.0
2020-10-21 17:00:00	IWM	ETF	159.57	159.68	159.57	159.62	4760.0
2020-10-21 18:00:00	IWM	ETF	159.61	159.7	159.49	159.51	22361.0
2020-10-21 19:00:00	IWM	ETF	159.67	159.67	158.08	158.75	65854.0
2020-10-21 04:00:00	DIA	ETF	283.39	283.39	282.48	282.48	3243.0
2020-10-21 05:00:00	DIA	ETF	282.25	283.03	282.25	283.03	1800.0

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

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