PREVIEW / etf_30min / 2019-05-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-05-01.parquet
  size:    503 KB
  rows:    17,564

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-01 04:00:00	SPY	ETF	295.27	295.38	295.27	295.34	2100.0
2019-05-01 04:30:00	SPY	ETF	295.31	295.32	295.22	295.22	3120.0
2019-05-01 05:00:00	SPY	ETF	295.21	295.23	295.19	295.19	800.0
2019-05-01 05:30:00	SPY	ETF	295.14	295.18	295.14	295.15	3265.0
2019-05-01 06:00:00	SPY	ETF	295.13	295.13	295.1	295.11	2396.0
2019-05-01 06:30:00	SPY	ETF	295.12	295.12	294.95	294.95	7200.0
2019-05-01 07:00:00	SPY	ETF	294.93	295.15	294.85	295.09	63854.0
2019-05-01 07:30:00	SPY	ETF	295.09	295.12	295.05	295.05	55990.0
2019-05-01 08:00:00	SPY	ETF	295.0601	295.25	294.98	295.15	77654.0
2019-05-01 08:30:00	SPY	ETF	295.14	295.24	294.85	294.95	512679.0
2019-05-01 09:00:00	SPY	ETF	294.95	294.95	294.69	294.72	244847.0
2019-05-01 09:30:00	SPY	ETF	294.72	294.785	294.33	294.47	5010252.0
2019-05-01 10:00:00	SPY	ETF	294.47	294.64	294.0	294.2266	3858137.0
2019-05-01 10:30:00	SPY	ETF	294.23	294.44	294.138	294.31	2194646.0
2019-05-01 11:00:00	SPY	ETF	294.305	294.56	294.22	294.445	1567716.0
2019-05-01 11:30:00	SPY	ETF	294.44	294.92	294.42	294.66	3742735.0
2019-05-01 12:00:00	SPY	ETF	294.66	294.69	293.95	294.17	2632575.0
2019-05-01 12:30:00	SPY	ETF	294.18	294.18	293.68	294.06	3286621.0
2019-05-01 13:00:00	SPY	ETF	294.07	294.44	293.87	294.1419	2692040.0
2019-05-01 13:30:00	SPY	ETF	294.145	294.39	294.06	294.35	1595690.0
2019-05-01 14:00:00	SPY	ETF	294.35	294.95	294.08	294.615	4430436.0
2019-05-01 14:30:00	SPY	ETF	294.615	294.8	293.27	293.78	8200553.0
2019-05-01 15:00:00	SPY	ETF	293.78	293.98	293.125	293.34	4960079.0
2019-05-01 15:30:00	SPY	ETF	293.345	293.35	291.8	291.84	15011226.0
2019-05-01 16:00:00	SPY	ETF	291.83	293.025	291.45	291.66	8921828.0
2019-05-01 16:30:00	SPY	ETF	291.66	294.0839	291.02	291.06	855879.0
2019-05-01 17:00:00	SPY	ETF	291.09	291.81	290.99	291.02	242969.0
2019-05-01 17:30:00	SPY	ETF	291.05	291.09	290.79	290.93	147954.0
2019-05-01 18:00:00	SPY	ETF	290.98	291.3	290.91	291.3	192984.0
2019-05-01 18:30:00	SPY	ETF	291.27	291.32	291.24	291.26	16181.0
2019-05-01 19:00:00	SPY	ETF	291.26	291.44	291.26	291.4	47894.0
2019-05-01 19:30:00	SPY	ETF	291.42	291.5	291.38	291.38	33123.0
2019-05-01 04:00:00	QQQ	ETF	191.05	191.17	191.05	191.17	4212.0
2019-05-01 04:30:00	QQQ	ETF	191.09	191.13	191.09	191.12	2915.0
2019-05-01 05:00:00	QQQ	ETF	191.1	191.11	191.02	191.06	3500.0
2019-05-01 05:30:00	QQQ	ETF	191.04	191.11	191.04	191.07	2294.0
2019-05-01 06:00:00	QQQ	ETF	191.04	191.06	191.0	191.02	4450.0
2019-05-01 06:30:00	QQQ	ETF	191.03	191.04	190.91	190.91	10000.0
2019-05-01 07:00:00	QQQ	ETF	190.91	191.04	190.86	190.95	54899.0
2019-05-01 07:30:00	QQQ	ETF	190.98	190.98	190.9	190.9	26630.0
2019-05-01 08:00:00	QQQ	ETF	190.8899	191.03	190.86	191.0	36305.0
2019-05-01 08:30:00	QQQ	ETF	191.02	191.08	190.82	190.88	120536.0
2019-05-01 09:00:00	QQQ	ETF	190.85	190.89	190.72	190.76	113563.0
2019-05-01 09:30:00	QQQ	ETF	190.76	190.86	190.45	190.63	2930192.0
2019-05-01 10:00:00	QQQ	ETF	190.63	191.02	190.26	190.64	1767353.0
2019-05-01 10:30:00	QQQ	ETF	190.64	190.86	190.54	190.72	866947.0
2019-05-01 11:00:00	QQQ	ETF	190.72	190.9468	190.64	190.86	603791.0
2019-05-01 11:30:00	QQQ	ETF	190.85	191.29	190.83	191.06	1495545.0
2019-05-01 12:00:00	QQQ	ETF	191.0825	191.13	190.59	190.75	819128.0
2019-05-01 12:30:00	QQQ	ETF	190.74	190.75	190.3234	190.52	1369932.0

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

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