PREVIEW / etf_1hour / 2020-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-29.parquet
  size:    359 KB
  rows:    11,733

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-29 04:00:00	SPY	ETF	328.05	328.2	327.56	327.66	18034.0
2020-01-29 05:00:00	SPY	ETF	327.69	328.11	327.67	328.11	12164.0
2020-01-29 06:00:00	SPY	ETF	328.25	328.46	328.0	328.38	47836.0
2020-01-29 07:00:00	SPY	ETF	328.32	328.55	328.13	328.23	215330.0
2020-01-29 08:00:00	SPY	ETF	328.4499	328.55	327.76	327.96	327725.0
2020-01-29 09:00:00	SPY	ETF	328.0	328.47	327.15	327.27	5035433.0
2020-01-29 10:00:00	SPY	ETF	327.28	327.89	326.4	327.82	8277728.0
2020-01-29 11:00:00	SPY	ETF	327.82	328.07	327.6	327.92	3504696.0
2020-01-29 12:00:00	SPY	ETF	327.91	328.08	327.77	327.83	3126988.0
2020-01-29 13:00:00	SPY	ETF	327.83	328.31	327.675	328.04	2767696.0
2020-01-29 14:00:00	SPY	ETF	328.04	328.63	327.74	327.7778	5773558.0
2020-01-29 15:00:00	SPY	ETF	327.78	327.89	326.55	326.62	15218639.0
2020-01-29 16:00:00	SPY	ETF	326.64	326.86	325.92	326.49	7730919.0
2020-01-29 17:00:00	SPY	ETF	326.5	326.62	326.37	326.5	546242.0
2020-01-29 18:00:00	SPY	ETF	326.55	327.09	326.47	326.77	199404.0
2020-01-29 19:00:00	SPY	ETF	326.77	326.84	325.92	326.12	100365.0
2020-01-29 04:00:00	QQQ	ETF	222.32	222.45	222.06	222.13	100298.0
2020-01-29 05:00:00	QQQ	ETF	222.19	222.54	222.18	222.47	40077.0
2020-01-29 06:00:00	QQQ	ETF	222.52	222.79	222.45	222.79	26822.0
2020-01-29 07:00:00	QQQ	ETF	222.7	222.83	222.51	222.6	160868.0
2020-01-29 08:00:00	QQQ	ETF	222.81	222.8101	222.01	222.4	198857.0
2020-01-29 09:00:00	QQQ	ETF	222.46	222.93	221.52	221.62	3138922.0
2020-01-29 10:00:00	QQQ	ETF	221.6	221.88	220.83	221.86	3727409.0
2020-01-29 11:00:00	QQQ	ETF	221.86	222.21	221.72	222.13	1875288.0
2020-01-29 12:00:00	QQQ	ETF	222.135	222.43	222.07	222.23	1142632.0
2020-01-29 13:00:00	QQQ	ETF	222.23	222.59	222.0225	222.4298	1166483.0
2020-01-29 14:00:00	QQQ	ETF	222.43	222.92	222.17	222.54	1958878.0
2020-01-29 15:00:00	QQQ	ETF	222.55	222.65	221.64	221.72	3917002.0
2020-01-29 16:00:00	QQQ	ETF	221.72	222.29	221.03	221.61	2255699.0
2020-01-29 17:00:00	QQQ	ETF	221.72	221.77	221.6	221.76	70526.0
2020-01-29 18:00:00	QQQ	ETF	221.77	222.36	221.62	222.0	185347.0
2020-01-29 19:00:00	QQQ	ETF	222.09	222.12	221.41	221.62	92492.0
2020-01-29 04:00:00	IWM	ETF	165.1	165.12	164.75	164.83	8500.0
2020-01-29 05:00:00	IWM	ETF	164.88	165.08	164.84	165.08	900.0
2020-01-29 06:00:00	IWM	ETF	165.09	165.17	165.01	165.17	13155.0
2020-01-29 07:00:00	IWM	ETF	165.199	165.2	164.99	165.09	4125.0
2020-01-29 08:00:00	IWM	ETF	165.2	165.2	164.87	164.87	53765.0
2020-01-29 09:00:00	IWM	ETF	164.93	165.56	164.69	164.71	1395764.0
2020-01-29 10:00:00	IWM	ETF	164.71	164.78	163.96	164.76	1970199.0
2020-01-29 11:00:00	IWM	ETF	164.76	165.0	164.48	164.65	1291172.0
2020-01-29 12:00:00	IWM	ETF	164.64	164.71	164.33	164.41	808704.0
2020-01-29 13:00:00	IWM	ETF	164.42	164.81	164.33	164.79	521310.0
2020-01-29 14:00:00	IWM	ETF	164.76	164.91	164.37	164.38	1048671.0
2020-01-29 15:00:00	IWM	ETF	164.38	164.43	163.9	163.93	3120281.0
2020-01-29 16:00:00	IWM	ETF	163.93	164.05	163.75	163.93	2638543.0
2020-01-29 17:00:00	IWM	ETF	163.8	163.85	163.8	163.82	1658.0
2020-01-29 18:00:00	IWM	ETF	163.92	164.24	163.91	163.91	12302.0
2020-01-29 19:00:00	IWM	ETF	164.03	164.03	163.58	163.66	16987.0
2020-01-29 04:00:00	DIA	ETF	287.8	287.8	287.8	287.8	500.0
2020-01-29 06:00:00	DIA	ETF	288.16	288.16	288.16	288.16	100.0

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

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