PREVIEW / etf_1hour / 2018-11-14

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-14.parquet
  size:    317 KB
  rows:    10,515

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
2018-11-14 04:00:00	SPY	ETF	271.1	271.85	270.85	271.68	81349.0
2018-11-14 05:00:00	SPY	ETF	271.68	272.62	271.48	272.56	49544.0
2018-11-14 06:00:00	SPY	ETF	272.52	272.57	271.81	271.94	73048.0
2018-11-14 07:00:00	SPY	ETF	271.94	272.9	271.94	272.51	304587.0
2018-11-14 08:00:00	SPY	ETF	272.26	274.1	271.0	273.85	1112172.0
2018-11-14 09:00:00	SPY	ETF	273.9	274.61	273.6	274.04	8198837.0
2018-11-14 10:00:00	SPY	ETF	274.05	274.0869	272.05	272.33	11335216.0
2018-11-14 11:00:00	SPY	ETF	272.33	272.34	270.35	271.38	16672201.0
2018-11-14 12:00:00	SPY	ETF	271.38	274.16	270.05	270.24	12678472.0
2018-11-14 13:00:00	SPY	ETF	270.23	270.77	269.0	269.51	13614912.0
2018-11-14 14:00:00	SPY	ETF	269.5	271.5	268.45	271.36	20283625.0
2018-11-14 15:00:00	SPY	ETF	271.36	272.14	269.53	270.14	25670223.0
2018-11-14 16:00:00	SPY	ETF	270.14	270.7927	269.38	270.02	12596207.0
2018-11-14 17:00:00	SPY	ETF	270.05	270.2	269.9	270.0	705217.0
2018-11-14 18:00:00	SPY	ETF	269.99	270.64	269.38	269.49	510787.0
2018-11-14 19:00:00	SPY	ETF	269.49	270.21	269.06	270.2	353264.0
2018-11-14 20:00:00	SPY	ETF	270.0538	270.2	270.0538	270.2	133906.0
2018-11-14 04:00:00	QQQ	ETF	165.09	165.61	165.04	165.61	40723.0
2018-11-14 05:00:00	QQQ	ETF	165.63	166.51	165.6	166.5	51759.0
2018-11-14 06:00:00	QQQ	ETF	166.52	166.52	165.91	165.93	32166.0
2018-11-14 07:00:00	QQQ	ETF	166.04	166.88	166.04	166.5	114094.0
2018-11-14 08:00:00	QQQ	ETF	166.3901	167.96	165.13	167.69	680551.0
2018-11-14 09:00:00	QQQ	ETF	167.71	168.7	167.41	167.8	6722911.0
2018-11-14 10:00:00	QQQ	ETF	167.76	167.84	166.0915	166.52	9359003.0
2018-11-14 11:00:00	QQQ	ETF	166.5	166.5	165.26	166.1	10867523.0
2018-11-14 12:00:00	QQQ	ETF	166.1	166.27	165.01	165.17	9392230.0
2018-11-14 13:00:00	QQQ	ETF	165.15	165.87	164.67	165.059	6760771.0
2018-11-14 14:00:00	QQQ	ETF	165.05	166.4	164.25	166.29	9202174.0
2018-11-14 15:00:00	QQQ	ETF	166.3	166.86	164.79	165.14	10220281.0
2018-11-14 16:00:00	QQQ	ETF	165.15	166.0315	164.52	165.18	3337467.0
2018-11-14 17:00:00	QQQ	ETF	165.18	165.3	165.09	165.2	886835.0
2018-11-14 18:00:00	QQQ	ETF	165.2	165.75	164.84	164.96	367025.0
2018-11-14 19:00:00	QQQ	ETF	164.98	165.58	164.71	165.52	264579.0
2018-11-14 04:00:00	IWM	ETF	149.74	150.11	149.74	150.11	9772.0
2018-11-14 05:00:00	IWM	ETF	150.26	150.75	150.26	150.66	4100.0
2018-11-14 06:00:00	IWM	ETF	150.7	150.83	150.64	150.83	7053.0
2018-11-14 07:00:00	IWM	ETF	151.11	151.22	150.91	150.91	12100.0
2018-11-14 08:00:00	IWM	ETF	150.25	151.76	150.25	151.69	127787.0
2018-11-14 09:00:00	IWM	ETF	151.77	152.5	151.5	152.22	3332840.0
2018-11-14 10:00:00	IWM	ETF	152.21	152.3	150.72	151.05	2559636.0
2018-11-14 11:00:00	IWM	ETF	151.04	151.05	149.64	150.29	2451641.0
2018-11-14 12:00:00	IWM	ETF	150.28	150.75	149.65	149.72	2356429.0
2018-11-14 13:00:00	IWM	ETF	149.7	149.96	148.83	149.04	2312552.0
2018-11-14 14:00:00	IWM	ETF	149.03	150.36	148.48	150.28	3272807.0
2018-11-14 15:00:00	IWM	ETF	150.28	150.73	149.36	149.44	4003212.0
2018-11-14 16:00:00	IWM	ETF	149.46	149.48	148.92	149.22	1570922.0
2018-11-14 17:00:00	IWM	ETF	149.44	149.45	149.25	149.25	125517.0
2018-11-14 18:00:00	IWM	ETF	149.25	149.5	148.79	148.91	26479.0
2018-11-14 19:00:00	IWM	ETF	148.84	149.29	148.62	149.24	17846.0
2018-11-14 04:00:00	DIA	ETF	252.49	253.0	252.49	252.84	300.0

> showing 50 of 10,515 rows — these rows as CSV

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