PREVIEW / etf_1hour / 2020-04-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-04-14.parquet
  size:    382 KB
  rows:    13,017

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-04-14 04:00:00	SPY	ETF	279.27	279.3	278.51	278.64	86309.0
2020-04-14 05:00:00	SPY	ETF	278.71	279.74	278.61	279.23	101005.0
2020-04-14 06:00:00	SPY	ETF	279.13	279.48	278.45	279.0	251893.0
2020-04-14 07:00:00	SPY	ETF	278.9	280.11	278.52	279.7	702183.0
2020-04-14 08:00:00	SPY	ETF	279.66	280.86	278.53	280.45	1089436.0
2020-04-14 09:00:00	SPY	ETF	280.46	282.87	279.91	282.84	15634280.0
2020-04-14 10:00:00	SPY	ETF	282.86	283.79	281.56	281.573	21002412.0
2020-04-14 11:00:00	SPY	ETF	281.58	282.09	280.1	281.161	18655270.0
2020-04-14 12:00:00	SPY	ETF	281.19	283.285	281.19	282.905	15817219.0
2020-04-14 13:00:00	SPY	ETF	282.9	284.0	282.3	283.73	10604047.0
2020-04-14 14:00:00	SPY	ETF	283.75	284.3	283.28	283.935	12595571.0
2020-04-14 15:00:00	SPY	ETF	283.94	284.9	282.55	283.87	27468499.0
2020-04-14 16:00:00	SPY	ETF	283.89	284.6	283.0341	284.56	6706945.0
2020-04-14 17:00:00	SPY	ETF	284.57	284.68	283.79	284.63	1255030.0
2020-04-14 18:00:00	SPY	ETF	284.63	284.63	283.84	283.99	339053.0
2020-04-14 19:00:00	SPY	ETF	283.98	284.19	283.25	283.4	292642.0
2020-04-14 04:00:00	QQQ	ETF	205.9	206.16	205.55	205.65	52521.0
2020-04-14 05:00:00	QQQ	ETF	205.64	206.34	205.64	206.16	18022.0
2020-04-14 06:00:00	QQQ	ETF	206.12	206.35	205.67	205.97	69187.0
2020-04-14 07:00:00	QQQ	ETF	205.91	206.72	205.64	206.63	238546.0
2020-04-14 08:00:00	QQQ	ETF	205.7601	207.25	203.0744	207.09	1501055.0
2020-04-14 09:00:00	QQQ	ETF	207.1	209.75	206.42	209.69	8025510.0
2020-04-14 10:00:00	QQQ	ETF	209.69	210.16	209.14	209.415	9318620.0
2020-04-14 11:00:00	QQQ	ETF	209.43	209.86	208.51	209.445	6364794.0
2020-04-14 12:00:00	QQQ	ETF	209.48	211.38	209.48	211.13	5757888.0
2020-04-14 13:00:00	QQQ	ETF	211.14	212.08	210.7442	211.91	4744693.0
2020-04-14 14:00:00	QQQ	ETF	211.94	212.25	211.49	212.01	5121021.0
2020-04-14 15:00:00	QQQ	ETF	212.02	212.5	210.97	211.85	10826612.0
2020-04-14 16:00:00	QQQ	ETF	211.85	212.45	210.6	212.36	1730767.0
2020-04-14 17:00:00	QQQ	ETF	212.41	212.55	212.13	212.55	301364.0
2020-04-14 18:00:00	QQQ	ETF	212.45	212.45	211.9	212.05	81927.0
2020-04-14 19:00:00	QQQ	ETF	212.05	212.19	211.6	211.71	121193.0
2020-04-14 04:00:00	IWM	ETF	122.83	122.97	122.5	122.56	6769.0
2020-04-14 05:00:00	IWM	ETF	122.9	123.19	122.86	122.86	3300.0
2020-04-14 06:00:00	IWM	ETF	122.81	123.08	122.51	122.6	56501.0
2020-04-14 07:00:00	IWM	ETF	122.79	123.19	122.49	123.02	71546.0
2020-04-14 08:00:00	IWM	ETF	123.01	123.61	122.5504	123.46	155189.0
2020-04-14 09:00:00	IWM	ETF	123.46	124.36	123.2	124.2364	4867775.0
2020-04-14 10:00:00	IWM	ETF	124.22	124.88	122.29	122.49	6777160.0
2020-04-14 11:00:00	IWM	ETF	122.49	122.7	121.3	122.01	4571275.0
2020-04-14 12:00:00	IWM	ETF	122.02	123.04	122.02	122.065	2713749.0
2020-04-14 13:00:00	IWM	ETF	122.06	123.24	121.93	123.06	3015989.0
2020-04-14 14:00:00	IWM	ETF	123.065	123.48	122.6	122.82	2361715.0
2020-04-14 15:00:00	IWM	ETF	122.81	123.32	122.23	122.91	6089131.0
2020-04-14 16:00:00	IWM	ETF	122.92	123.29	122.74	123.17	846535.0
2020-04-14 17:00:00	IWM	ETF	123.2	123.25	122.81	123.15	103661.0
2020-04-14 18:00:00	IWM	ETF	123.09	123.14	122.87	122.96	7601.0
2020-04-14 19:00:00	IWM	ETF	122.94	122.97	122.57	122.7	12370.0
2020-04-14 04:00:00	DIA	ETF	237.0	237.26	236.86	237.01	2948.0
2020-04-14 05:00:00	DIA	ETF	237.15	237.48	237.06	237.06	2400.0

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

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