PREVIEW / etf_30min / 2019-10-08

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-08.parquet
  size:    515 KB
  rows:    18,080

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-10-08 04:00:00	SPY	ETF	292.65	293.04	292.65	293.02	3625.0
2019-10-08 04:30:00	SPY	ETF	292.97	293.08	292.67	292.86	25376.0
2019-10-08 05:00:00	SPY	ETF	292.84	292.95	292.52	292.52	47157.0
2019-10-08 05:30:00	SPY	ETF	292.53	292.53	292.1	292.3	67359.0
2019-10-08 06:00:00	SPY	ETF	292.3	292.3	291.25	291.7	121273.0
2019-10-08 06:30:00	SPY	ETF	291.68	291.83	291.36	291.54	135200.0
2019-10-08 07:00:00	SPY	ETF	291.58	291.58	290.49	291.13	636125.0
2019-10-08 07:30:00	SPY	ETF	291.12	291.7	291.04	291.3	235020.0
2019-10-08 08:00:00	SPY	ETF	291.26	293.99	290.89	291.33	310002.0
2019-10-08 08:30:00	SPY	ETF	291.35	291.48	291.0	291.23	378259.0
2019-10-08 09:00:00	SPY	ETF	291.25	291.54	291.0	291.04	485355.0
2019-10-08 09:30:00	SPY	ETF	291.04	291.04	289.66	289.66	10314524.0
2019-10-08 10:00:00	SPY	ETF	289.66	289.9	289.07	289.45	6580320.0
2019-10-08 10:30:00	SPY	ETF	289.45	290.23	289.07	290.16	5912558.0
2019-10-08 11:00:00	SPY	ETF	290.15	290.38	289.4	289.4588	3862799.0
2019-10-08 11:30:00	SPY	ETF	289.4552	289.72	288.88	289.55	3967323.0
2019-10-08 12:00:00	SPY	ETF	289.54	290.23	289.2984	290.0	3017597.0
2019-10-08 12:30:00	SPY	ETF	289.99	291.11	289.8	290.34	5554586.0
2019-10-08 13:00:00	SPY	ETF	290.33	290.75	290.08	290.68	2332987.0
2019-10-08 13:30:00	SPY	ETF	290.69	291.045	290.415	290.62	2634225.0
2019-10-08 14:00:00	SPY	ETF	290.63	290.73	290.18	290.54	3127098.0
2019-10-08 14:30:00	SPY	ETF	290.535	291.85	289.69	290.47	10660200.0
2019-10-08 15:00:00	SPY	ETF	290.46	291.12	289.74	290.3699	6680879.0
2019-10-08 15:30:00	SPY	ETF	290.365	290.66	288.49	288.55	18240184.0
2019-10-08 16:00:00	SPY	ETF	288.55	293.1257	288.47	288.58	8349604.0
2019-10-08 16:30:00	SPY	ETF	288.58	288.8	288.48	288.72	1972649.0
2019-10-08 17:00:00	SPY	ETF	288.73	288.74	288.56	288.63	121582.0
2019-10-08 17:30:00	SPY	ETF	288.62	290.9	288.6	288.72	1590427.0
2019-10-08 18:00:00	SPY	ETF	288.73	288.93	288.65	288.75	61906.0
2019-10-08 18:30:00	SPY	ETF	288.78	288.85	288.27	288.42	68721.0
2019-10-08 19:00:00	SPY	ETF	288.33	288.68	288.23	288.57	44920.0
2019-10-08 19:30:00	SPY	ETF	288.48	288.64	288.42	288.53	30724.0
2019-10-08 04:00:00	QQQ	ETF	188.24	188.35	188.15	188.35	87267.0
2019-10-08 04:30:00	QQQ	ETF	188.37	188.37	188.09	188.23	37454.0
2019-10-08 05:00:00	QQQ	ETF	188.23	188.3	187.97	187.97	42815.0
2019-10-08 05:30:00	QQQ	ETF	187.97	187.99	187.74	187.91	68020.0
2019-10-08 06:00:00	QQQ	ETF	187.85	187.85	187.1	187.34	120504.0
2019-10-08 06:30:00	QQQ	ETF	187.36	187.43	187.16	187.27	54331.0
2019-10-08 07:00:00	QQQ	ETF	187.31	187.34	186.57	187.04	150793.0
2019-10-08 07:30:00	QQQ	ETF	187.04	187.49	186.99	187.19	71443.0
2019-10-08 08:00:00	QQQ	ETF	187.15	188.17	186.76	187.15	182126.0
2019-10-08 08:30:00	QQQ	ETF	187.15	187.3	186.92	187.09	288530.0
2019-10-08 09:00:00	QQQ	ETF	187.11	188.24	186.95	187.02	312087.0
2019-10-08 09:30:00	QQQ	ETF	187.01	187.195	185.94	186.01	4425765.0
2019-10-08 10:00:00	QQQ	ETF	186.02	186.22	185.54	186.0	2815079.0
2019-10-08 10:30:00	QQQ	ETF	186.0	186.54	185.72	186.51	1764082.0
2019-10-08 11:00:00	QQQ	ETF	186.48	186.73	186.02	186.08	1362253.0
2019-10-08 11:30:00	QQQ	ETF	186.08	186.33	185.74	186.21	1397920.0
2019-10-08 12:00:00	QQQ	ETF	186.21	186.63	186.01	186.52	753141.0
2019-10-08 12:30:00	QQQ	ETF	186.52	187.34	186.32	186.76	1285342.0

> showing 50 of 18,080 rows — these rows as CSV

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