PREVIEW / etf_30min / 2019-05-06

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-06.parquet
  size:    518 KB
  rows:    18,050

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-06 04:00:00	SPY	ETF	289.4	289.5	289.03	289.16	76922.0
2019-05-06 04:30:00	SPY	ETF	289.11	289.11	288.68	288.83	19479.0
2019-05-06 05:00:00	SPY	ETF	288.86	288.88	288.68	288.81	9940.0
2019-05-06 05:30:00	SPY	ETF	288.81	289.15	288.74	289.15	13002.0
2019-05-06 06:00:00	SPY	ETF	289.18	289.28	288.99	289.16	30197.0
2019-05-06 06:30:00	SPY	ETF	289.13	289.6	289.13	289.39	177375.0
2019-05-06 07:00:00	SPY	ETF	289.39	289.68	289.25	289.4	473021.0
2019-05-06 07:30:00	SPY	ETF	289.41	289.81	289.41	289.62	554162.0
2019-05-06 08:00:00	SPY	ETF	289.62	289.99	288.17	289.94	647372.0
2019-05-06 08:30:00	SPY	ETF	289.94	289.98	289.55	289.74	742486.0
2019-05-06 09:00:00	SPY	ETF	289.74	289.81	289.08	289.2	1296357.0
2019-05-06 09:30:00	SPY	ETF	289.25	290.96	288.9	290.949	14647610.0
2019-05-06 10:00:00	SPY	ETF	290.945	291.4	290.45	291.04	8335150.0
2019-05-06 10:30:00	SPY	ETF	291.04	291.63	290.87	291.52	5868568.0
2019-05-06 11:00:00	SPY	ETF	291.51	291.92	291.22	291.885	4416791.0
2019-05-06 11:30:00	SPY	ETF	291.88	291.95	291.26	291.34	7162893.0
2019-05-06 12:00:00	SPY	ETF	291.3399	291.44	291.11	291.19	5068575.0
2019-05-06 12:30:00	SPY	ETF	291.19	291.56	291.15	291.16	2536861.0
2019-05-06 13:00:00	SPY	ETF	291.14	291.67	290.97	291.64	3958929.0
2019-05-06 13:30:00	SPY	ETF	291.635	291.74	291.53	291.74	2067481.0
2019-05-06 14:00:00	SPY	ETF	291.74	292.06	291.58	292.0132	2471878.0
2019-05-06 14:30:00	SPY	ETF	292.015	293.05	291.99	293.03	5905506.0
2019-05-06 15:00:00	SPY	ETF	293.02	293.22	292.79	293.05	5108360.0
2019-05-06 15:30:00	SPY	ETF	293.045	293.31	292.69	292.87	9552948.0
2019-05-06 16:00:00	SPY	ETF	292.87	294.126	292.54	292.82	11936740.0
2019-05-06 16:30:00	SPY	ETF	292.83	292.89	290.38	290.51	812537.0
2019-05-06 17:00:00	SPY	ETF	290.51	291.69	290.41	291.35	1574450.0
2019-05-06 17:30:00	SPY	ETF	291.35	291.41	290.92	290.95	299216.0
2019-05-06 18:00:00	SPY	ETF	290.95	291.23	290.64	290.98	362487.0
2019-05-06 18:30:00	SPY	ETF	290.98	291.15	290.98	291.09	20974.0
2019-05-06 19:00:00	SPY	ETF	291.09	291.15	291.0	291.13	22992.0
2019-05-06 19:30:00	SPY	ETF	291.12	291.37	291.12	291.28	101059.0
2019-05-06 04:00:00	QQQ	ETF	187.54	187.54	187.18	187.3	41448.0
2019-05-06 04:30:00	QQQ	ETF	187.26	187.28	186.69	186.85	13248.0
2019-05-06 05:00:00	QQQ	ETF	186.83	186.91	186.68	186.75	23401.0
2019-05-06 05:30:00	QQQ	ETF	186.8	187.1	186.8	187.1	28256.0
2019-05-06 06:00:00	QQQ	ETF	187.12	187.25	186.94	187.13	16394.0
2019-05-06 06:30:00	QQQ	ETF	187.12	187.38	187.08	187.33	38596.0
2019-05-06 07:00:00	QQQ	ETF	187.28	187.52	187.24	187.37	127572.0
2019-05-06 07:30:00	QQQ	ETF	187.38	187.65	187.38	187.56	128654.0
2019-05-06 08:00:00	QQQ	ETF	187.36	187.92	186.85	187.89	342337.0
2019-05-06 08:30:00	QQQ	ETF	187.88	187.89	187.55	187.75	207325.0
2019-05-06 09:00:00	QQQ	ETF	187.74	187.78	186.99	187.09	552122.0
2019-05-06 09:30:00	QQQ	ETF	187.1	188.62	186.76	188.5589	6279992.0
2019-05-06 10:00:00	QQQ	ETF	188.57	189.0	188.15	188.76	3631732.0
2019-05-06 10:30:00	QQQ	ETF	188.76	189.25	188.52	189.16	3202558.0
2019-05-06 11:00:00	QQQ	ETF	189.1694	189.42	188.88	189.33	1727632.0
2019-05-06 11:30:00	QQQ	ETF	189.34	189.45	188.89	188.96	1776061.0
2019-05-06 12:00:00	QQQ	ETF	188.98	189.06	188.5601	188.6062	1938972.0
2019-05-06 12:30:00	QQQ	ETF	188.59	188.95	188.46	188.5	1188812.0

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

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