PREVIEW / etf_30min / 2019-07-12

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-07-12.parquet
  size:    495 KB
  rows:    17,206

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-07-12 04:00:00	SPY	ETF	299.84	300.05	299.84	300.0	3002.0
2019-07-12 04:30:00	SPY	ETF	300.03	300.06	300.03	300.05	12650.0
2019-07-12 05:00:00	SPY	ETF	300.07	300.14	300.02	300.09	31810.0
2019-07-12 05:30:00	SPY	ETF	300.07	300.16	300.02	300.08	9789.0
2019-07-12 06:00:00	SPY	ETF	300.13	300.18	300.07	300.12	28046.0
2019-07-12 06:30:00	SPY	ETF	300.1	300.2	299.85	300.01	26081.0
2019-07-12 07:00:00	SPY	ETF	300.0	300.08	299.95	299.95	22543.0
2019-07-12 07:30:00	SPY	ETF	299.92	300.03	299.86	300.0	62675.0
2019-07-12 08:00:00	SPY	ETF	299.99	300.12	299.31	300.08	107203.0
2019-07-12 08:30:00	SPY	ETF	300.03	300.13	299.93	299.96	108646.0
2019-07-12 09:00:00	SPY	ETF	299.99	300.02	299.85	299.85	76266.0
2019-07-12 09:30:00	SPY	ETF	299.85	300.0	299.62	299.75	4474810.0
2019-07-12 10:00:00	SPY	ETF	299.75	300.0	299.63	299.795	2730874.0
2019-07-12 10:30:00	SPY	ETF	299.795	299.86	299.51	299.615	2268865.0
2019-07-12 11:00:00	SPY	ETF	299.62	300.0	299.52	299.99	1811127.0
2019-07-12 11:30:00	SPY	ETF	300.0	300.06	299.8	299.97	1918470.0
2019-07-12 12:00:00	SPY	ETF	299.97	300.03	299.82	299.89	1581864.0
2019-07-12 12:30:00	SPY	ETF	299.88	300.11	299.81	300.1	2316115.0
2019-07-12 13:00:00	SPY	ETF	300.105	300.14	299.99	300.07	1016881.0
2019-07-12 13:30:00	SPY	ETF	300.075	300.075	299.91	299.9901	984074.0
2019-07-12 14:00:00	SPY	ETF	299.99	300.22	299.97	300.145	1955716.0
2019-07-12 14:30:00	SPY	ETF	300.15	300.36	300.13	300.35	2612545.0
2019-07-12 15:00:00	SPY	ETF	300.34	300.4308	300.16	300.31	4036259.0
2019-07-12 15:30:00	SPY	ETF	300.31	300.73	300.31	300.68	7192658.0
2019-07-12 16:00:00	SPY	ETF	300.68	300.7152	300.42	300.43	3749969.0
2019-07-12 16:30:00	SPY	ETF	300.46	300.57	300.37	300.37	199696.0
2019-07-12 17:00:00	SPY	ETF	300.42	300.65	300.38	300.48	47338.0
2019-07-12 17:30:00	SPY	ETF	300.5	300.65	300.4	300.4	28171.0
2019-07-12 18:00:00	SPY	ETF	300.47	300.49	300.4	300.48	6825.0
2019-07-12 18:30:00	SPY	ETF	300.45	300.45	300.38	300.38	11175.0
2019-07-12 19:00:00	SPY	ETF	300.43	300.44	300.38	300.44	2603.0
2019-07-12 19:30:00	SPY	ETF	300.43	300.5	300.37	300.44	11646.0
2019-07-12 04:00:00	QQQ	ETF	192.69	192.98	192.69	192.98	7414.0
2019-07-12 04:30:00	QQQ	ETF	192.98	192.99	192.89	192.96	9800.0
2019-07-12 05:00:00	QQQ	ETF	192.96	193.02	192.9	192.98	10360.0
2019-07-12 05:30:00	QQQ	ETF	192.94	192.99	192.9	192.95	11932.0
2019-07-12 06:00:00	QQQ	ETF	192.99	193.08	192.99	193.02	12099.0
2019-07-12 06:30:00	QQQ	ETF	193.01	193.1	192.77	192.87	40555.0
2019-07-12 07:00:00	QQQ	ETF	192.89	192.96	192.81	192.86	35778.0
2019-07-12 07:30:00	QQQ	ETF	192.8	192.88	192.72	192.81	24429.0
2019-07-12 08:00:00	QQQ	ETF	192.9101	192.98	192.77	192.94	56611.0
2019-07-12 08:30:00	QQQ	ETF	192.86	192.92	192.72	192.75	67618.0
2019-07-12 09:00:00	QQQ	ETF	192.75	192.79	192.58	192.63	46797.0
2019-07-12 09:30:00	QQQ	ETF	192.63	193.105	192.56	192.88	1797492.0
2019-07-12 10:00:00	QQQ	ETF	192.86	193.15	192.59	192.75	1515684.0
2019-07-12 10:30:00	QQQ	ETF	192.76	192.82	192.45	192.66	1253526.0
2019-07-12 11:00:00	QQQ	ETF	192.6641	193.09	192.58	193.06	797422.0
2019-07-12 11:30:00	QQQ	ETF	193.08	193.15	193.01	193.14	718069.0
2019-07-12 12:00:00	QQQ	ETF	193.14	193.3	193.13	193.15	856731.0
2019-07-12 12:30:00	QQQ	ETF	193.13	193.335	193.07	193.32	615331.0

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

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