PREVIEW / etf_30min / 2019-05-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-08.parquet
  size:    495 KB
  rows:    17,347

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-05-08 04:00:00	SPY	ETF	288.98	289.42	288.91	289.19	10981.0
2019-05-08 04:30:00	SPY	ETF	289.11	289.11	288.41	288.69	13003.0
2019-05-08 05:00:00	SPY	ETF	288.57	288.59	287.94	288.22	8250.0
2019-05-08 05:30:00	SPY	ETF	288.17	288.17	287.37	287.37	18059.0
2019-05-08 06:00:00	SPY	ETF	287.44	287.49	287.16	287.36	12960.0
2019-05-08 06:30:00	SPY	ETF	287.31	287.58	287.24	287.46	33131.0
2019-05-08 07:00:00	SPY	ETF	287.44	287.45	286.49	286.99	223439.0
2019-05-08 07:30:00	SPY	ETF	286.93	287.21	286.72	287.13	363670.0
2019-05-08 08:00:00	SPY	ETF	287.38	289.0	286.44	287.29	869949.0
2019-05-08 08:30:00	SPY	ETF	287.34	288.21	286.61	287.66	2212356.0
2019-05-08 09:00:00	SPY	ETF	287.65	287.65	287.22	287.56	1004564.0
2019-05-08 09:30:00	SPY	ETF	287.53	288.28	286.87	287.99	10216963.0
2019-05-08 10:00:00	SPY	ETF	288.015	288.42	287.64	287.68	5847907.0
2019-05-08 10:30:00	SPY	ETF	287.69	288.75	287.24	288.71	5095138.0
2019-05-08 11:00:00	SPY	ETF	288.72	289.43	288.37	288.62	11692273.0
2019-05-08 11:30:00	SPY	ETF	288.63	288.84	287.8	288.38	8415184.0
2019-05-08 12:00:00	SPY	ETF	288.37	288.46	287.745	288.38	3236989.0
2019-05-08 12:30:00	SPY	ETF	288.3623	288.96	288.22	288.9567	2072601.0
2019-05-08 13:00:00	SPY	ETF	288.95	289.11	288.51	288.7183	2451378.0
2019-05-08 13:30:00	SPY	ETF	288.715	288.84	288.4	288.72	3083305.0
2019-05-08 14:00:00	SPY	ETF	288.73	288.795	288.32	288.723	2935845.0
2019-05-08 14:30:00	SPY	ETF	288.73	288.96	288.56	288.765	2233733.0
2019-05-08 15:00:00	SPY	ETF	288.77	289.24	288.73	289.21	2941327.0
2019-05-08 15:30:00	SPY	ETF	289.21	289.25	287.44	287.56	14756780.0
2019-05-08 16:00:00	SPY	ETF	287.57	288.86	287.53	288.18	8742923.0
2019-05-08 16:30:00	SPY	ETF	288.16	288.16	287.91	287.97	539435.0
2019-05-08 17:00:00	SPY	ETF	287.97	288.04	287.5358	287.88	386172.0
2019-05-08 17:30:00	SPY	ETF	287.89	287.91	287.8	287.89	119278.0
2019-05-08 18:00:00	SPY	ETF	287.9	287.96	287.53	287.8	114884.0
2019-05-08 18:30:00	SPY	ETF	287.81	288.05	287.81	287.98	25237.0
2019-05-08 19:00:00	SPY	ETF	287.91	288.06	287.8	288.0	10416.0
2019-05-08 19:30:00	SPY	ETF	288.01	288.01	287.64	287.72	34483.0
2019-05-08 04:00:00	QQQ	ETF	186.79	187.33	186.0	187.21	11069.0
2019-05-08 04:30:00	QQQ	ETF	187.17	187.17	186.57	186.89	66914.0
2019-05-08 05:00:00	QQQ	ETF	186.55	186.61	186.34	186.39	13020.0
2019-05-08 05:30:00	QQQ	ETF	186.37	186.41	185.83	185.83	29298.0
2019-05-08 06:00:00	QQQ	ETF	185.8	185.99	185.61	185.71	23565.0
2019-05-08 06:30:00	QQQ	ETF	185.71	185.91	185.67	185.85	43710.0
2019-05-08 07:00:00	QQQ	ETF	185.81	185.81	185.09	185.43	169110.0
2019-05-08 07:30:00	QQQ	ETF	185.41	185.58	185.23	185.52	179710.0
2019-05-08 08:00:00	QQQ	ETF	185.39	186.85	185.09	185.62	185186.0
2019-05-08 08:30:00	QQQ	ETF	185.61	186.16	185.01	185.76	917962.0
2019-05-08 09:00:00	QQQ	ETF	185.7701	185.78	185.39	185.68	522709.0
2019-05-08 09:30:00	QQQ	ETF	185.67	186.44	184.96	186.09	6749103.0
2019-05-08 10:00:00	QQQ	ETF	186.1	186.36	185.78	185.8176	2246635.0
2019-05-08 10:30:00	QQQ	ETF	185.82	186.77	185.38	186.73	2087498.0
2019-05-08 11:00:00	QQQ	ETF	186.74	187.17	186.41	186.64	3987649.0
2019-05-08 11:30:00	QQQ	ETF	186.65	186.8	185.91	186.27	2414121.0
2019-05-08 12:00:00	QQQ	ETF	186.27	186.38	185.85	186.31	1124762.0
2019-05-08 12:30:00	QQQ	ETF	186.2999	186.86	186.21	186.7832	980003.0

> showing 50 of 17,347 rows — these rows as CSV

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