PREVIEW / etf_1hour / 2020-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-09.parquet
  size:    377 KB
  rows:    12,858

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-09 04:00:00	SPY	ETF	345.0	345.3	344.85	345.04	55610.0
2020-10-09 05:00:00	SPY	ETF	345.01	345.13	344.87	345.08	23729.0
2020-10-09 06:00:00	SPY	ETF	345.06	345.53	344.69	344.72	44331.0
2020-10-09 07:00:00	SPY	ETF	344.7	345.45	344.65	345.23	126058.0
2020-10-09 08:00:00	SPY	ETF	345.21	345.96	343.78	345.74	499501.0
2020-10-09 09:00:00	SPY	ETF	345.79	346.1	345.11	345.55	5266963.0
2020-10-09 10:00:00	SPY	ETF	345.545	345.7	344.89	345.56	6005054.0
2020-10-09 11:00:00	SPY	ETF	345.57	347.19	345.56	346.97	8311196.0
2020-10-09 12:00:00	SPY	ETF	346.96	347.35	346.51	346.67	9146104.0
2020-10-09 13:00:00	SPY	ETF	346.68	346.92	346.39	346.91	2973813.0
2020-10-09 14:00:00	SPY	ETF	346.92	346.92	345.95	346.36	5320888.0
2020-10-09 15:00:00	SPY	ETF	346.343	346.99	346.12	346.84	13039019.0
2020-10-09 16:00:00	SPY	ETF	346.83	347.88	346.69	347.56	7708477.0
2020-10-09 17:00:00	SPY	ETF	347.53	347.6	346.85	347.26	105173.0
2020-10-09 18:00:00	SPY	ETF	347.27	347.27	347.15	347.22	50066.0
2020-10-09 19:00:00	SPY	ETF	347.22	347.27	347.15	347.25	34718.0
2020-10-09 04:00:00	QQQ	ETF	282.18	282.6	282.1	282.46	33688.0
2020-10-09 05:00:00	QQQ	ETF	282.46	282.5	282.28	282.29	22400.0
2020-10-09 06:00:00	QQQ	ETF	282.24	282.58	281.91	281.96	20602.0
2020-10-09 07:00:00	QQQ	ETF	281.97	282.72	281.97	282.64	91264.0
2020-10-09 08:00:00	QQQ	ETF	282.3699	283.41	281.95	283.3	238139.0
2020-10-09 09:00:00	QQQ	ETF	283.26	283.95	282.71	283.79	2643942.0
2020-10-09 10:00:00	QQQ	ETF	283.8	284.46	283.33	284.3	3256257.0
2020-10-09 11:00:00	QQQ	ETF	284.31	285.13	284.2	284.9	3542052.0
2020-10-09 12:00:00	QQQ	ETF	284.89	285.39	284.53	285.12	2773804.0
2020-10-09 13:00:00	QQQ	ETF	285.13	285.56	284.76	285.24	1854751.0
2020-10-09 14:00:00	QQQ	ETF	285.235	285.3999	284.6	284.79	2092131.0
2020-10-09 15:00:00	QQQ	ETF	284.78	285.79	284.66	285.73	4516025.0
2020-10-09 16:00:00	QQQ	ETF	285.73	286.34	285.2	286.08	1073590.0
2020-10-09 17:00:00	QQQ	ETF	286.19	286.25	286.0	286.2	25450.0
2020-10-09 18:00:00	QQQ	ETF	286.24	286.27	286.06	286.21	17794.0
2020-10-09 19:00:00	QQQ	ETF	286.2	286.26	286.11	286.22	18475.0
2020-10-09 04:00:00	IWM	ETF	163.01	163.07	162.85	163.03	2931.0
2020-10-09 05:00:00	IWM	ETF	162.86	162.98	162.86	162.95	708.0
2020-10-09 06:00:00	IWM	ETF	163.22	163.31	162.98	162.99	18285.0
2020-10-09 07:00:00	IWM	ETF	163.01	163.36	162.98	163.258	24233.0
2020-10-09 08:00:00	IWM	ETF	163.14	163.61	162.5	163.43	180040.0
2020-10-09 09:00:00	IWM	ETF	163.45	163.71	162.84	163.08	2032396.0
2020-10-09 10:00:00	IWM	ETF	163.095	163.095	161.805	162.0319	3670981.0
2020-10-09 11:00:00	IWM	ETF	162.04	163.05	161.9	162.67	3171586.0
2020-10-09 12:00:00	IWM	ETF	162.64	163.42	162.53	163.27	2480643.0
2020-10-09 13:00:00	IWM	ETF	163.26	163.27	162.69	162.8281	1588108.0
2020-10-09 14:00:00	IWM	ETF	162.815	162.85	162.51	162.72	1494136.0
2020-10-09 15:00:00	IWM	ETF	162.721	162.93	162.555	162.69	2820348.0
2020-10-09 16:00:00	IWM	ETF	162.7	163.36	162.634	163.22	1449429.0
2020-10-09 17:00:00	IWM	ETF	162.71	163.26	162.71	163.04	14739.0
2020-10-09 18:00:00	IWM	ETF	163.07	163.07	162.95	162.98	8217.0
2020-10-09 19:00:00	IWM	ETF	163.01	163.05	162.94	162.98	3559.0
2020-10-09 04:00:00	DIA	ETF	285.41	285.45	285.26	285.37	5600.0
2020-10-09 05:00:00	DIA	ETF	285.24	285.25	285.24	285.25	500.0

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

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