PREVIEW / etf_30min / 2019-08-20

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-20.parquet
  size:    501 KB
  rows:    17,479

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-20 04:00:00	SPY	ETF	292.55	292.7	292.48	292.7	3824.0
2019-08-20 04:30:00	SPY	ETF	292.68	292.73	292.58	292.58	1854.0
2019-08-20 05:00:00	SPY	ETF	292.53	292.53	292.25	292.35	4782.0
2019-08-20 05:30:00	SPY	ETF	292.36	292.53	292.36	292.48	10327.0
2019-08-20 06:00:00	SPY	ETF	292.6	292.6	292.6	292.6	1100.0
2019-08-20 06:30:00	SPY	ETF	292.48	292.48	292.25	292.25	7878.0
2019-08-20 07:00:00	SPY	ETF	292.25	292.32	291.97	292.06	38895.0
2019-08-20 07:30:00	SPY	ETF	292.04	292.57	292.0	292.54	208541.0
2019-08-20 08:00:00	SPY	ETF	292.3601	293.0	291.99	292.63	107182.0
2019-08-20 08:30:00	SPY	ETF	292.62	292.78	292.09	292.09	159423.0
2019-08-20 09:00:00	SPY	ETF	292.07	292.21	291.58	291.79	526707.0
2019-08-20 09:30:00	SPY	ETF	291.77	291.91	290.35	290.7	6421014.0
2019-08-20 10:00:00	SPY	ETF	290.71	291.36	290.5	291.29	4346523.0
2019-08-20 10:30:00	SPY	ETF	291.28	291.865	290.82	291.8167	2781451.0
2019-08-20 11:00:00	SPY	ETF	291.825	292.36	291.69	291.8499	2722666.0
2019-08-20 11:30:00	SPY	ETF	291.83	291.95	291.36	291.5145	1709415.0
2019-08-20 12:00:00	SPY	ETF	291.54	291.975	291.54	291.8	1579433.0
2019-08-20 12:30:00	SPY	ETF	291.8	291.85	291.38	291.78	1299524.0
2019-08-20 13:00:00	SPY	ETF	291.77	291.85	291.47	291.56	1158310.0
2019-08-20 13:30:00	SPY	ETF	291.56	291.6	290.81	291.25	2357294.0
2019-08-20 14:00:00	SPY	ETF	291.24	291.2849	290.35	290.76	4868573.0
2019-08-20 14:30:00	SPY	ETF	290.75	291.04	290.61	290.855	1642022.0
2019-08-20 15:00:00	SPY	ETF	290.84	290.96	290.34	290.94	2491104.0
2019-08-20 15:30:00	SPY	ETF	290.92	290.96	289.95	290.05	9817013.0
2019-08-20 16:00:00	SPY	ETF	290.06	290.1917	289.7	289.74	5338260.0
2019-08-20 16:30:00	SPY	ETF	289.74	289.82	289.34	289.49	249790.0
2019-08-20 17:00:00	SPY	ETF	289.51	289.51	289.41	289.51	14999.0
2019-08-20 17:30:00	SPY	ETF	289.53	289.54	289.37	289.37	27917.0
2019-08-20 18:00:00	SPY	ETF	289.36	289.86	289.26	289.76	64193.0
2019-08-20 18:30:00	SPY	ETF	289.83	289.87	289.76	289.84	24561.0
2019-08-20 19:00:00	SPY	ETF	289.8	289.84	289.58	289.75	15898.0
2019-08-20 19:30:00	SPY	ETF	289.76	290.0	289.75	289.85	15508.0
2019-08-20 04:00:00	QQQ	ETF	188.67	188.68	188.5	188.61	5637.0
2019-08-20 04:30:00	QQQ	ETF	188.68	188.75	188.54	188.57	4792.0
2019-08-20 05:00:00	QQQ	ETF	188.58	188.6	188.28	188.44	10715.0
2019-08-20 05:30:00	QQQ	ETF	188.47	188.58	188.46	188.51	7187.0
2019-08-20 06:00:00	QQQ	ETF	188.59	188.72	188.58	188.69	7308.0
2019-08-20 06:30:00	QQQ	ETF	188.67	188.67	188.34	188.43	11400.0
2019-08-20 07:00:00	QQQ	ETF	188.39	188.4	188.08	188.12	94081.0
2019-08-20 07:30:00	QQQ	ETF	188.1	188.51	188.09	188.51	154372.0
2019-08-20 08:00:00	QQQ	ETF	188.21	188.8	188.11	188.61	40881.0
2019-08-20 08:30:00	QQQ	ETF	188.61	188.75	188.21	188.23	94344.0
2019-08-20 09:00:00	QQQ	ETF	188.19	188.34	187.8	188.04	177511.0
2019-08-20 09:30:00	QQQ	ETF	188.0	188.13	187.15	187.51	2819030.0
2019-08-20 10:00:00	QQQ	ETF	187.47	187.96	187.3	187.9	1308024.0
2019-08-20 10:30:00	QQQ	ETF	187.89	188.27	187.52	188.2346	1035594.0
2019-08-20 11:00:00	QQQ	ETF	188.26	188.635	188.07	188.26	1237658.0
2019-08-20 11:30:00	QQQ	ETF	188.26	188.3227	187.98	188.06	761262.0
2019-08-20 12:00:00	QQQ	ETF	188.06	188.4	188.06	188.28	450192.0
2019-08-20 12:30:00	QQQ	ETF	188.2869	188.32	187.94	188.2	607586.0

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

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