PREVIEW / etf_30min / 2019-06-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-17.parquet
  size:    478 KB
  rows:    16,760

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-06-17 04:00:00	SPY	ETF	289.8	289.91	289.73	289.73	1248.0
2019-06-17 04:30:00	SPY	ETF	289.8	289.81	289.78	289.78	1988.0
2019-06-17 05:00:00	SPY	ETF	289.94	289.95	289.77	289.77	6651.0
2019-06-17 05:30:00	SPY	ETF	289.87	289.88	289.75	289.78	6605.0
2019-06-17 06:00:00	SPY	ETF	289.8	289.8	289.64	289.69	10132.0
2019-06-17 06:30:00	SPY	ETF	289.66	289.73	289.49	289.49	14634.0
2019-06-17 07:00:00	SPY	ETF	289.54	289.74	289.47	289.7	36125.0
2019-06-17 07:30:00	SPY	ETF	289.72	289.94	289.67	289.92	76307.0
2019-06-17 08:00:00	SPY	ETF	289.91	290.25	289.5	289.82	78127.0
2019-06-17 08:30:00	SPY	ETF	289.81	289.86	289.34	289.39	295238.0
2019-06-17 09:00:00	SPY	ETF	289.39	289.67	289.39	289.5	203881.0
2019-06-17 09:30:00	SPY	ETF	289.52	289.92	289.19	289.765	4531271.0
2019-06-17 10:00:00	SPY	ETF	289.76	289.99	289.56	289.94	3766077.0
2019-06-17 10:30:00	SPY	ETF	289.94	290.2041	289.82	290.03	3179555.0
2019-06-17 11:00:00	SPY	ETF	290.03	290.22	289.83	289.85	2315944.0
2019-06-17 11:30:00	SPY	ETF	289.85	289.89	289.64	289.74	1844396.0
2019-06-17 12:00:00	SPY	ETF	289.74	289.81	289.54	289.565	1104860.0
2019-06-17 12:30:00	SPY	ETF	289.56	289.82	289.5	289.77	1339875.0
2019-06-17 13:00:00	SPY	ETF	289.77	289.88	289.7	289.72	1536950.0
2019-06-17 13:30:00	SPY	ETF	289.71	290.01	289.69	289.98	1249039.0
2019-06-17 14:00:00	SPY	ETF	289.98	290.14	289.78	289.78	2947555.0
2019-06-17 14:30:00	SPY	ETF	289.78	289.91	289.7	289.73	1784048.0
2019-06-17 15:00:00	SPY	ETF	289.735	289.9	289.58	289.83	2452729.0
2019-06-17 15:30:00	SPY	ETF	289.83	289.835	289.18	289.44	6143430.0
2019-06-17 16:00:00	SPY	ETF	289.45	289.67	289.37	289.64	2643590.0
2019-06-17 16:30:00	SPY	ETF	289.64	289.73	289.37	289.73	268114.0
2019-06-17 17:00:00	SPY	ETF	289.69	289.78	289.65	289.73	74017.0
2019-06-17 17:30:00	SPY	ETF	289.68	289.73	289.67	289.7	19049.0
2019-06-17 18:00:00	SPY	ETF	289.74	289.78	289.73	289.75	78059.0
2019-06-17 18:30:00	SPY	ETF	289.75	289.79	289.67	289.68	21112.0
2019-06-17 19:00:00	SPY	ETF	289.68	289.75	289.68	289.69	14143.0
2019-06-17 19:30:00	SPY	ETF	289.7	289.73	289.55	289.62	36174.0
2019-06-17 04:00:00	QQQ	ETF	182.88	183.03	182.84	182.92	12756.0
2019-06-17 04:30:00	QQQ	ETF	182.97	183.0	182.89	182.98	8220.0
2019-06-17 05:00:00	QQQ	ETF	183.07	183.14	182.97	182.98	22945.0
2019-06-17 05:30:00	QQQ	ETF	183.03	183.03	182.87	182.91	15780.0
2019-06-17 06:00:00	QQQ	ETF	182.93	182.95	182.76	182.8	18842.0
2019-06-17 06:30:00	QQQ	ETF	182.8	182.85	182.65	182.68	20154.0
2019-06-17 07:00:00	QQQ	ETF	182.73	182.93	182.66	182.85	51548.0
2019-06-17 07:30:00	QQQ	ETF	182.85	183.14	182.83	183.06	75967.0
2019-06-17 08:00:00	QQQ	ETF	182.71	183.12	182.6799	183.02	83854.0
2019-06-17 08:30:00	QQQ	ETF	183.0	183.04	182.74	182.77	122617.0
2019-06-17 09:00:00	QQQ	ETF	182.81	183.06	182.81	183.01	99070.0
2019-06-17 09:30:00	QQQ	ETF	183.0	184.18	182.835	183.96	3313176.0
2019-06-17 10:00:00	QQQ	ETF	183.97	184.095	183.68	183.97	2063737.0
2019-06-17 10:30:00	QQQ	ETF	183.99	184.23	183.91	184.11	1084586.0
2019-06-17 11:00:00	QQQ	ETF	184.11	184.25	183.76	183.83	769652.0
2019-06-17 11:30:00	QQQ	ETF	183.825	183.93	183.65	183.72	808651.0
2019-06-17 12:00:00	QQQ	ETF	183.7	183.8	183.61	183.6874	405918.0
2019-06-17 12:30:00	QQQ	ETF	183.67	183.92	183.59	183.87	804454.0

> showing 50 of 16,760 rows — these rows as CSV

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