PREVIEW / etf_1hour / 2020-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-11.parquet
  size:    396 KB
  rows:    13,393

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-03-11 04:00:00	SPY	ETF	281.3	284.06	279.5	283.05	161762.0
2020-03-11 05:00:00	SPY	ETF	283.18	283.18	280.68	281.79	77856.0
2020-03-11 06:00:00	SPY	ETF	281.7	282.51	279.81	281.38	271047.0
2020-03-11 07:00:00	SPY	ETF	281.49	281.74	278.58	279.85	1108929.0
2020-03-11 08:00:00	SPY	ETF	281.35	288.42	277.0	277.11	2428016.0
2020-03-11 09:00:00	SPY	ETF	277.06	281.94	277.0	280.47	20710392.0
2020-03-11 10:00:00	SPY	ETF	280.45	281.48	277.23	278.505	31872758.0
2020-03-11 11:00:00	SPY	ETF	278.53	279.4261	276.16	277.94	28473459.0
2020-03-11 12:00:00	SPY	ETF	277.95	280.74	275.57	276.52	30539152.0
2020-03-11 13:00:00	SPY	ETF	276.49	277.04	274.7	275.97	22933531.0
2020-03-11 14:00:00	SPY	ETF	275.96	276.43	273.34	273.66	31929907.0
2020-03-11 15:00:00	SPY	ETF	273.7	276.33	270.88	274.36	66106116.0
2020-03-11 16:00:00	SPY	ETF	274.36	279.0514	273.9	274.7	15655449.0
2020-03-11 17:00:00	SPY	ETF	274.61	274.93	273.74	274.2	847105.0
2020-03-11 18:00:00	SPY	ETF	274.22	277.87	274.04	277.26	1168590.0
2020-03-11 19:00:00	SPY	ETF	277.24	277.24	273.33	273.9	615023.0
2020-03-11 04:00:00	QQQ	ETF	199.61	201.34	197.9	200.65	134498.0
2020-03-11 05:00:00	QQQ	ETF	200.63	200.76	199.03	199.88	64921.0
2020-03-11 06:00:00	QQQ	ETF	199.86	200.33	198.47	199.66	85576.0
2020-03-11 07:00:00	QQQ	ETF	199.73	200.0	197.93	198.7	519367.0
2020-03-11 08:00:00	QQQ	ETF	198.7	200.0	197.1	197.28	822199.0
2020-03-11 09:00:00	QQQ	ETF	197.27	204.11	197.21	199.7	6626895.0
2020-03-11 10:00:00	QQQ	ETF	199.69	200.75	197.44	198.13	11024642.0
2020-03-11 11:00:00	QQQ	ETF	198.16	198.74	196.88	197.73	7757269.0
2020-03-11 12:00:00	QQQ	ETF	197.77	199.6499	196.18	196.7	7881012.0
2020-03-11 13:00:00	QQQ	ETF	196.69	196.99	195.48	196.29	8673663.0
2020-03-11 14:00:00	QQQ	ETF	196.3	196.63	194.44	194.8134	10446766.0
2020-03-11 15:00:00	QQQ	ETF	194.86	196.99	192.73	195.3	16645819.0
2020-03-11 16:00:00	QQQ	ETF	195.32	196.19	194.91	195.48	1965657.0
2020-03-11 17:00:00	QQQ	ETF	195.79	195.79	194.73	194.9	187084.0
2020-03-11 18:00:00	QQQ	ETF	195.19	197.92	195.02	197.59	396020.0
2020-03-11 19:00:00	QQQ	ETF	197.57	197.57	194.84	195.2901	299605.0
2020-03-11 04:00:00	IWM	ETF	130.77	132.0	130.0	132.0	9878.0
2020-03-11 05:00:00	IWM	ETF	131.31	131.32	130.56	131.1	5259.0
2020-03-11 06:00:00	IWM	ETF	131.0	131.36	130.35	131.1	18632.0
2020-03-11 07:00:00	IWM	ETF	130.99	131.1	130.0	130.54	95330.0
2020-03-11 08:00:00	IWM	ETF	130.54	130.84	129.4	129.47	265633.0
2020-03-11 09:00:00	IWM	ETF	129.57	134.43	129.01	129.91	3957362.0
2020-03-11 10:00:00	IWM	ETF	129.89	130.8	128.61	129.13	4981708.0
2020-03-11 11:00:00	IWM	ETF	129.16	129.45	126.87	128.08	6418267.0
2020-03-11 12:00:00	IWM	ETF	128.09	129.56	127.2021	127.69	4625250.0
2020-03-11 13:00:00	IWM	ETF	127.7	128.0	126.865	127.37	3274843.0
2020-03-11 14:00:00	IWM	ETF	127.38	127.6	125.91	125.99	4099493.0
2020-03-11 15:00:00	IWM	ETF	125.99	126.66	124.17	125.92	11124124.0
2020-03-11 16:00:00	IWM	ETF	125.92	134.5563	125.59	126.03	2088472.0
2020-03-11 17:00:00	IWM	ETF	126.19	126.19	125.51	125.88	81265.0
2020-03-11 18:00:00	IWM	ETF	125.81	127.26	125.71	127.08	63992.0
2020-03-11 19:00:00	IWM	ETF	126.95	126.95	125.36	125.75	113333.0
2020-03-11 04:00:00	DIA	ETF	244.82	246.61	243.09	246.37	6018.0
2020-03-11 05:00:00	DIA	ETF	245.7	245.7	244.52	244.52	800.0

> showing 50 of 13,393 rows — these rows as CSV

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