PREVIEW / etf_1hour / 2020-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-09.parquet
  size:    421 KB
  rows:    14,622

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-09 04:00:00	SPY	ETF	280.2	289.4	276.54	278.91	324011.0
2020-03-09 05:00:00	SPY	ETF	278.75	283.13	278.16	279.31	308635.0
2020-03-09 06:00:00	SPY	ETF	279.85	281.51	278.5	279.25	227001.0
2020-03-09 07:00:00	SPY	ETF	279.5	281.0	277.18	278.5	1256312.0
2020-03-09 08:00:00	SPY	ETF	277.35	282.82	275.67	277.38	2590836.0
2020-03-09 09:00:00	SPY	ETF	277.38	281.66	273.5	279.93	21318295.0
2020-03-09 10:00:00	SPY	ETF	279.77	282.63	278.33	278.61	42502695.0
2020-03-09 11:00:00	SPY	ETF	278.61	284.08	278.02	282.69	36250118.0
2020-03-09 12:00:00	SPY	ETF	282.69	284.19	279.01	279.71	30558772.0
2020-03-09 13:00:00	SPY	ETF	279.71	280.71	275.34	275.84	30905208.0
2020-03-09 14:00:00	SPY	ETF	275.84	277.64	273.45	276.59	47111518.0
2020-03-09 15:00:00	SPY	ETF	276.63	279.33	274.37	274.4	71265828.0
2020-03-09 16:00:00	SPY	ETF	274.41	275.95	272.83	274.0	18072576.0
2020-03-09 17:00:00	SPY	ETF	274.0	276.25	273.37	274.1	732383.0
2020-03-09 18:00:00	SPY	ETF	274.04	277.37	270.27	277.05	1721482.0
2020-03-09 19:00:00	SPY	ETF	277.15	297.3813	277.06	280.25	1696857.0
2020-03-09 04:00:00	QQQ	ETF	197.53	199.0	194.01	195.64	63196.0
2020-03-09 05:00:00	QQQ	ETF	195.6	198.45	195.24	196.6	92501.0
2020-03-09 06:00:00	QQQ	ETF	196.71	197.12	195.51	196.4	102018.0
2020-03-09 07:00:00	QQQ	ETF	196.21	197.9	195.0	195.49	257501.0
2020-03-09 08:00:00	QQQ	ETF	195.5	208.02	194.0	194.73	602530.0
2020-03-09 09:00:00	QQQ	ETF	194.78	197.89	192.11	197.25	6678705.0
2020-03-09 10:00:00	QQQ	ETF	197.25	199.63	195.97	196.8237	17076345.0
2020-03-09 11:00:00	QQQ	ETF	196.82	200.7	196.325	200.04	12543120.0
2020-03-09 12:00:00	QQQ	ETF	200.02	201.16	197.69	198.23	9434938.0
2020-03-09 13:00:00	QQQ	ETF	198.23	199.0566	195.27	195.61	8958869.0
2020-03-09 14:00:00	QQQ	ETF	195.6	196.95	194.04	196.03	12845916.0
2020-03-09 15:00:00	QQQ	ETF	196.03	197.6	193.55	193.65	23947602.0
2020-03-09 16:00:00	QQQ	ETF	193.61	194.38	192.44	193.26	4293043.0
2020-03-09 17:00:00	QQQ	ETF	193.24	195.1	192.75	193.24	150492.0
2020-03-09 18:00:00	QQQ	ETF	193.1	195.94	190.91	195.73	532426.0
2020-03-09 19:00:00	QQQ	ETF	195.63	198.65	195.63	198.02	683696.0
2020-03-09 04:00:00	IWM	ETF	137.1	137.1	134.0	135.0	10850.0
2020-03-09 05:00:00	IWM	ETF	135.89	137.0	135.89	136.25	42734.0
2020-03-09 06:00:00	IWM	ETF	136.58	136.58	135.25	135.25	24206.0
2020-03-09 07:00:00	IWM	ETF	136.51	136.58	133.0	133.92	67708.0
2020-03-09 08:00:00	IWM	ETF	135.2	137.39	133.01	134.99	104928.0
2020-03-09 09:00:00	IWM	ETF	134.91	135.9984	133.4	134.72	1837885.0
2020-03-09 10:00:00	IWM	ETF	134.785	135.93	133.11	133.13	8172762.0
2020-03-09 11:00:00	IWM	ETF	133.13	136.0	132.95	135.55	5225729.0
2020-03-09 12:00:00	IWM	ETF	135.53	136.17	133.58	133.98	3754012.0
2020-03-09 13:00:00	IWM	ETF	134.0	134.21	131.47	131.59	4418338.0
2020-03-09 14:00:00	IWM	ETF	131.58	131.85	130.26	131.52	5773373.0
2020-03-09 15:00:00	IWM	ETF	131.52	132.53	130.34	130.37	12030314.0
2020-03-09 16:00:00	IWM	ETF	130.37	131.79	129.96	130.01	4331350.0
2020-03-09 17:00:00	IWM	ETF	130.18	131.07	129.4	130.09	748294.0
2020-03-09 18:00:00	IWM	ETF	130.0	131.67	128.86	131.65	113682.0
2020-03-09 19:00:00	IWM	ETF	131.89	133.94	131.66	133.3	58890.0
2020-03-09 04:00:00	DIA	ETF	246.0	246.0	241.86	243.1	3143.0
2020-03-09 05:00:00	DIA	ETF	243.8	245.8	243.15	244.48	5573.0

> showing 50 of 14,622 rows — these rows as CSV

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