PREVIEW / etf_1hour / 2019-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-15.parquet
  size:    348 KB
  rows:    11,442

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
2019-08-15 04:00:00	SPY	ETF	285.55	286.25	285.37	285.75	49512.0
2019-08-15 05:00:00	SPY	ETF	285.71	285.78	283.14	283.8	168550.0
2019-08-15 06:00:00	SPY	ETF	283.76	283.77	281.63	282.79	407114.0
2019-08-15 07:00:00	SPY	ETF	282.75	286.35	282.71	285.7	1977774.0
2019-08-15 08:00:00	SPY	ETF	282.86	287.07	282.7301	285.68	3236135.0
2019-08-15 09:00:00	SPY	ETF	285.64	285.94	283.35	285.15	15010318.0
2019-08-15 10:00:00	SPY	ETF	285.16	285.64	284.11	284.63	10642547.0
2019-08-15 11:00:00	SPY	ETF	284.64	284.96	283.34	284.91	9763723.0
2019-08-15 12:00:00	SPY	ETF	284.91	285.47	284.24	284.52	7726052.0
2019-08-15 13:00:00	SPY	ETF	284.53	285.01	282.39	282.68	10856239.0
2019-08-15 14:00:00	SPY	ETF	282.69	284.34	282.41	284.16	12372087.0
2019-08-15 15:00:00	SPY	ETF	284.17	285.43	284.17	284.69	17456351.0
2019-08-15 16:00:00	SPY	ETF	284.67	285.09	283.6118	285.03	8920462.0
2019-08-15 17:00:00	SPY	ETF	285.09	285.24	284.78	284.87	1681425.0
2019-08-15 18:00:00	SPY	ETF	284.9	285.6	284.9	285.47	211486.0
2019-08-15 19:00:00	SPY	ETF	285.47	285.55	285.16	285.29	61299.0
2019-08-15 04:00:00	QQQ	ETF	183.44	184.0	183.19	183.6	44155.0
2019-08-15 05:00:00	QQQ	ETF	183.52	183.57	181.35	181.73	114319.0
2019-08-15 06:00:00	QQQ	ETF	181.69	181.79	180.02	180.99	224829.0
2019-08-15 07:00:00	QQQ	ETF	180.98	183.87	180.95	183.41	605782.0
2019-08-15 08:00:00	QQQ	ETF	183.41	184.47	180.91	183.69	842650.0
2019-08-15 09:00:00	QQQ	ETF	183.63	183.91	181.78	183.13	7096568.0
2019-08-15 10:00:00	QQQ	ETF	183.12	183.4235	182.38	182.61	4453667.0
2019-08-15 11:00:00	QQQ	ETF	182.61	182.94	181.635	182.92	3721626.0
2019-08-15 12:00:00	QQQ	ETF	182.9098	183.35	182.34	182.6	2612344.0
2019-08-15 13:00:00	QQQ	ETF	182.6001	183.0	181.16	181.39	3072086.0
2019-08-15 14:00:00	QQQ	ETF	181.36	182.45	181.17	182.26	3418030.0
2019-08-15 15:00:00	QQQ	ETF	182.28	183.15	182.28	182.58	5513617.0
2019-08-15 16:00:00	QQQ	ETF	182.57	182.94	182.5	182.9	1060876.0
2019-08-15 17:00:00	QQQ	ETF	182.91	183.0	182.72	182.8	37797.0
2019-08-15 18:00:00	QQQ	ETF	182.89	183.32	182.89	183.16	43796.0
2019-08-15 19:00:00	QQQ	ETF	183.18	183.29	183.02	183.07	28983.0
2019-08-15 04:00:00	IWM	ETF	147.08	147.34	147.0	147.34	6580.0
2019-08-15 05:00:00	IWM	ETF	146.45	146.45	145.98	146.19	15146.0
2019-08-15 06:00:00	IWM	ETF	146.26	146.26	145.24	145.69	13911.0
2019-08-15 07:00:00	IWM	ETF	145.76	147.56	145.7	146.83	122678.0
2019-08-15 08:00:00	IWM	ETF	145.86	147.75	145.86	147.11	110472.0
2019-08-15 09:00:00	IWM	ETF	147.02	147.14	145.3	146.32	4247824.0
2019-08-15 10:00:00	IWM	ETF	146.32	146.51	145.82	146.09	2552900.0
2019-08-15 11:00:00	IWM	ETF	146.09	146.15	145.35	145.77	2056567.0
2019-08-15 12:00:00	IWM	ETF	145.78	146.21	145.57	145.71	1612072.0
2019-08-15 13:00:00	IWM	ETF	145.71	146.01	144.791	144.89	2784710.0
2019-08-15 14:00:00	IWM	ETF	144.9	145.47	144.795	145.3	2566542.0
2019-08-15 15:00:00	IWM	ETF	145.32	145.81	145.24	145.53	5291546.0
2019-08-15 16:00:00	IWM	ETF	145.53	145.78	145.45	145.78	1009828.0
2019-08-15 17:00:00	IWM	ETF	145.6	145.78	145.6	145.77	14148.0
2019-08-15 18:00:00	IWM	ETF	145.75	146.01	145.75	145.97	10795.0
2019-08-15 19:00:00	IWM	ETF	145.96	146.05	145.91	145.91	755.0
2019-08-15 04:00:00	DIA	ETF	256.37	257.03	256.37	257.03	18700.0
2019-08-15 05:00:00	DIA	ETF	256.33	256.33	254.31	254.69	11400.0

> showing 50 of 11,442 rows — these rows as CSV

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