PREVIEW / etf_1hour / 2020-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-04.parquet
  size:    370 KB
  rows:    12,609

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-05-04 04:00:00	SPY	ETF	280.56	281.12	279.71	279.8	114843.0
2020-05-04 05:00:00	SPY	ETF	279.69	279.89	278.69	279.89	138355.0
2020-05-04 06:00:00	SPY	ETF	279.94	280.51	279.61	279.99	223339.0
2020-05-04 07:00:00	SPY	ETF	280.03	280.85	279.69	280.36	422519.0
2020-05-04 08:00:00	SPY	ETF	280.31	281.55	279.7	280.44	827310.0
2020-05-04 09:00:00	SPY	ETF	280.4	281.02	279.13	280.57	11305084.0
2020-05-04 10:00:00	SPY	ETF	280.58	282.11	280.44	280.6901	12944343.0
2020-05-04 11:00:00	SPY	ETF	280.7	281.88	280.53	281.42	9434295.0
2020-05-04 12:00:00	SPY	ETF	281.42	282.05	280.91	281.09	5726507.0
2020-05-04 13:00:00	SPY	ETF	281.1	281.49	280.2	281.46	7576303.0
2020-05-04 14:00:00	SPY	ETF	281.44	282.61	281.11	282.4791	8513910.0
2020-05-04 15:00:00	SPY	ETF	282.47	283.9	282.26	283.66	15408002.0
2020-05-04 16:00:00	SPY	ETF	283.64	283.7135	280.55	283.14	6850652.0
2020-05-04 17:00:00	SPY	ETF	283.15	283.57	282.9	282.9	309208.0
2020-05-04 18:00:00	SPY	ETF	282.9	283.69	282.86	283.13	300135.0
2020-05-04 19:00:00	SPY	ETF	283.13	283.52	282.95	283.51	106843.0
2020-05-04 04:00:00	QQQ	ETF	211.43	211.92	210.96	211.11	62406.0
2020-05-04 05:00:00	QQQ	ETF	211.0	211.04	210.4	211.04	44324.0
2020-05-04 06:00:00	QQQ	ETF	211.12	211.47	210.91	210.97	79047.0
2020-05-04 07:00:00	QQQ	ETF	211.04	211.81	210.72	211.48	153530.0
2020-05-04 08:00:00	QQQ	ETF	211.52	212.18	210.75	211.44	721315.0
2020-05-04 09:00:00	QQQ	ETF	211.3	212.93	210.45	212.78	5253104.0
2020-05-04 10:00:00	QQQ	ETF	212.83	214.03	212.67	213.115	5185295.0
2020-05-04 11:00:00	QQQ	ETF	213.115	214.34	212.975	213.96	3257996.0
2020-05-04 12:00:00	QQQ	ETF	213.95	214.24	212.755	212.9155	2383239.0
2020-05-04 13:00:00	QQQ	ETF	212.95	213.48	212.32	213.46	2535884.0
2020-05-04 14:00:00	QQQ	ETF	213.46	214.3	213.16	214.2	2921821.0
2020-05-04 15:00:00	QQQ	ETF	214.2	215.45	214.0	215.22	5950560.0
2020-05-04 16:00:00	QQQ	ETF	215.19	215.22	214.6	215.02	473123.0
2020-05-04 17:00:00	QQQ	ETF	215.05	215.06	214.95	214.95	28247.0
2020-05-04 18:00:00	QQQ	ETF	214.77	215.43	214.77	215.07	74379.0
2020-05-04 19:00:00	QQQ	ETF	214.95	215.38	214.88	215.38	43213.0
2020-05-04 04:00:00	IWM	ETF	123.88	124.09	123.25	123.49	7651.0
2020-05-04 05:00:00	IWM	ETF	123.13	123.31	122.58	123.2	19653.0
2020-05-04 06:00:00	IWM	ETF	123.28	123.91	123.18	123.6	92896.0
2020-05-04 07:00:00	IWM	ETF	123.74	124.12	123.45	123.85	200051.0
2020-05-04 08:00:00	IWM	ETF	123.53	124.21	123.46	123.56	171690.0
2020-05-04 09:00:00	IWM	ETF	123.44	124.85	122.25	124.7	4440223.0
2020-05-04 10:00:00	IWM	ETF	124.685	125.9	123.65	123.8	5143168.0
2020-05-04 11:00:00	IWM	ETF	123.81	124.5	123.53	124.13	2943879.0
2020-05-04 12:00:00	IWM	ETF	124.13	124.88	123.685	123.73	2212050.0
2020-05-04 13:00:00	IWM	ETF	123.73	124.175	123.18	124.12	1852820.0
2020-05-04 14:00:00	IWM	ETF	124.11	124.86	123.92	124.77	1903650.0
2020-05-04 15:00:00	IWM	ETF	124.77	125.9	124.655	125.67	5001634.0
2020-05-04 16:00:00	IWM	ETF	125.66	125.756	125.04	125.34	666650.0
2020-05-04 17:00:00	IWM	ETF	125.52	125.52	125.2	125.39	30964.0
2020-05-04 18:00:00	IWM	ETF	125.38	125.85	125.26	125.49	52018.0
2020-05-04 19:00:00	IWM	ETF	125.5	125.7	125.46	125.65	13950.0
2020-05-04 04:00:00	DIA	ETF	235.59	235.87	234.84	234.99	4497.0
2020-05-04 05:00:00	DIA	ETF	234.5	234.5	234.0	234.5	1923.0

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

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