PREVIEW / etf_1hour / 2020-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-08-25.parquet
  size:    370 KB
  rows:    12,544

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-08-25 04:00:00	SPY	ETF	344.57	344.6	343.88	344.09	22678.0
2020-08-25 05:00:00	SPY	ETF	343.82	344.16	343.82	344.14	10465.0
2020-08-25 06:00:00	SPY	ETF	344.14	344.32	343.96	344.26	17242.0
2020-08-25 07:00:00	SPY	ETF	344.25	344.44	344.0	344.29	142545.0
2020-08-25 08:00:00	SPY	ETF	344.33	344.59	343.7	344.11	165797.0
2020-08-25 09:00:00	SPY	ETF	344.1	344.23	342.86	343.35	4701459.0
2020-08-25 10:00:00	SPY	ETF	343.36	343.36	342.27	342.745	6395763.0
2020-08-25 11:00:00	SPY	ETF	342.745	343.48	342.35	342.71	4552170.0
2020-08-25 12:00:00	SPY	ETF	342.715	343.155	342.35	343.06	2779100.0
2020-08-25 13:00:00	SPY	ETF	343.06	343.39	342.825	343.19	2417720.0
2020-08-25 14:00:00	SPY	ETF	343.19	343.8	343.01	343.7399	3560676.0
2020-08-25 15:00:00	SPY	ETF	343.735	344.21	343.53	344.0999	8714503.0
2020-08-25 16:00:00	SPY	ETF	344.09	344.57	343.5429	344.45	3973457.0
2020-08-25 17:00:00	SPY	ETF	344.57	344.57	344.29	344.5	129818.0
2020-08-25 18:00:00	SPY	ETF	344.49	344.59	344.39	344.4899	83458.0
2020-08-25 19:00:00	SPY	ETF	344.47	344.74	344.4	344.55	54173.0
2020-08-25 04:00:00	QQQ	ETF	284.9	284.91	284.3	284.47	37748.0
2020-08-25 05:00:00	QQQ	ETF	284.35	284.54	284.27	284.36	7525.0
2020-08-25 06:00:00	QQQ	ETF	284.29	284.46	284.09	284.17	22179.0
2020-08-25 07:00:00	QQQ	ETF	284.25	284.35	283.35	283.46	137617.0
2020-08-25 08:00:00	QQQ	ETF	283.42	285.18	283.19	283.55	355495.0
2020-08-25 09:00:00	QQQ	ETF	283.57	283.77	282.37	283.51	5553416.0
2020-08-25 10:00:00	QQQ	ETF	283.52	284.18	282.69	284.045	5249566.0
2020-08-25 11:00:00	QQQ	ETF	284.06	285.22	283.82	284.36	3702637.0
2020-08-25 12:00:00	QQQ	ETF	284.37	284.72	283.58	284.5288	2145426.0
2020-08-25 13:00:00	QQQ	ETF	284.52	284.97	284.22	284.59	1782033.0
2020-08-25 14:00:00	QQQ	ETF	284.6	285.43	284.38	285.38	2566411.0
2020-08-25 15:00:00	QQQ	ETF	285.37	286.06	285.18	285.82	4215284.0
2020-08-25 16:00:00	QQQ	ETF	285.82	286.46	284.4491	286.29	899547.0
2020-08-25 17:00:00	QQQ	ETF	286.2701	286.39	286.23	286.321	26682.0
2020-08-25 18:00:00	QQQ	ETF	286.37	286.39	286.07	286.27	143339.0
2020-08-25 19:00:00	QQQ	ETF	286.2101	286.74	286.2101	286.609	213944.0
2020-08-25 04:00:00	IWM	ETF	157.14	157.31	156.94	157.02	10300.0
2020-08-25 05:00:00	IWM	ETF	156.94	157.23	156.94	157.21	4795.0
2020-08-25 06:00:00	IWM	ETF	157.25	157.54	157.08	157.53	21157.0
2020-08-25 07:00:00	IWM	ETF	157.48	157.66	157.3	157.3	96581.0
2020-08-25 08:00:00	IWM	ETF	157.49	157.8	156.92	157.12	99625.0
2020-08-25 09:00:00	IWM	ETF	157.12	157.4	155.94	156.66	1963298.0
2020-08-25 10:00:00	IWM	ETF	156.66	156.74	155.09	155.48	2524379.0
2020-08-25 11:00:00	IWM	ETF	155.49	155.69	154.79	155.01	2038970.0
2020-08-25 12:00:00	IWM	ETF	155.02	155.83	154.94	155.66	937807.0
2020-08-25 13:00:00	IWM	ETF	155.6667	155.955	155.51	155.76	736425.0
2020-08-25 14:00:00	IWM	ETF	155.77	156.32	155.53	156.195	1467999.0
2020-08-25 15:00:00	IWM	ETF	156.19	156.59	156.07	156.4	2092975.0
2020-08-25 16:00:00	IWM	ETF	156.41	156.57	156.33	156.44	586367.0
2020-08-25 17:00:00	IWM	ETF	156.44	156.54	156.44	156.54	17961.0
2020-08-25 18:00:00	IWM	ETF	156.5	156.52	156.4	156.5	12828.0
2020-08-25 19:00:00	IWM	ETF	156.45	156.54	156.45	156.47	4136.0
2020-08-25 04:00:00	DIA	ETF	285.02	285.02	284.34	284.34	2500.0
2020-08-25 05:00:00	DIA	ETF	284.12	284.6	284.1	284.6	1481.0

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

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