PREVIEW / etf_30min / 2019-02-20

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-20.parquet
  size:    500 KB
  rows:    17,515

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-02-20 04:00:00	SPY	ETF	277.72	277.87	277.7	277.7	1138.0
2019-02-20 04:30:00	SPY	ETF	277.45	277.45	277.27	277.27	7321.0
2019-02-20 05:00:00	SPY	ETF	277.38	277.45	277.37	277.45	1300.0
2019-02-20 05:30:00	SPY	ETF	277.38	277.59	277.38	277.56	5060.0
2019-02-20 06:00:00	SPY	ETF	277.56	277.56	277.37	277.37	690.0
2019-02-20 06:30:00	SPY	ETF	277.42	277.56	277.42	277.56	2600.0
2019-02-20 07:00:00	SPY	ETF	277.6	277.66	277.53	277.59	12758.0
2019-02-20 07:30:00	SPY	ETF	277.62	277.65	277.55	277.59	30549.0
2019-02-20 08:00:00	SPY	ETF	277.58	277.64	277.38	277.5	58143.0
2019-02-20 08:30:00	SPY	ETF	277.5	277.77	277.47	277.68	172832.0
2019-02-20 09:00:00	SPY	ETF	277.68	277.95	277.65	277.82	129510.0
2019-02-20 09:30:00	SPY	ETF	277.81	278.08	277.64	278.02	5521181.0
2019-02-20 10:00:00	SPY	ETF	278.025	278.23	277.74	278.18	3170783.0
2019-02-20 10:30:00	SPY	ETF	278.18	278.43	278.11	278.11	2378380.0
2019-02-20 11:00:00	SPY	ETF	278.11	278.23	278.0	278.19	1909295.0
2019-02-20 11:30:00	SPY	ETF	278.19	278.54	278.12	278.36	5376622.0
2019-02-20 12:00:00	SPY	ETF	278.37	278.405	277.59	277.62	4102378.0
2019-02-20 12:30:00	SPY	ETF	277.62	277.9	277.45	277.66	3375398.0
2019-02-20 13:00:00	SPY	ETF	277.64	278.32	277.6	278.3	2526206.0
2019-02-20 13:30:00	SPY	ETF	278.31	278.62	278.16	278.42	2819776.0
2019-02-20 14:00:00	SPY	ETF	278.42	278.92	277.25	277.853	10729005.0
2019-02-20 14:30:00	SPY	ETF	277.85	278.647	277.84	278.43	8184678.0
2019-02-20 15:00:00	SPY	ETF	278.43	278.59	278.24	278.33	4489375.0
2019-02-20 15:30:00	SPY	ETF	278.34	278.56	278.11	278.44	11938935.0
2019-02-20 16:00:00	SPY	ETF	278.44	278.63	278.2951	278.57	8453048.0
2019-02-20 16:30:00	SPY	ETF	278.57	278.63	278.41	278.52	249799.0
2019-02-20 17:00:00	SPY	ETF	278.55	278.6	278.52	278.55	44367.0
2019-02-20 17:30:00	SPY	ETF	278.55	278.55	278.48	278.5	27979.0
2019-02-20 18:00:00	SPY	ETF	278.5	278.5	278.36	278.38	43353.0
2019-02-20 18:30:00	SPY	ETF	278.4	278.47	278.4	278.47	13976.0
2019-02-20 19:00:00	SPY	ETF	278.46	278.59	278.3	278.3	38530.0
2019-02-20 19:30:00	SPY	ETF	278.38	278.4	278.28	278.32	12300.0
2019-02-20 04:00:00	QQQ	ETF	172.28	172.3	172.28	172.3	400.0
2019-02-20 04:30:00	QQQ	ETF	172.12	172.12	171.97	171.97	4900.0
2019-02-20 05:00:00	QQQ	ETF	171.97	172.19	171.97	172.17	1000.0
2019-02-20 06:00:00	QQQ	ETF	172.22	172.22	172.12	172.17	7300.0
2019-02-20 06:30:00	QQQ	ETF	172.1	172.13	171.99	172.13	7800.0
2019-02-20 07:00:00	QQQ	ETF	172.23	172.27	172.2	172.27	14752.0
2019-02-20 07:30:00	QQQ	ETF	172.27	172.28	172.18	172.18	10815.0
2019-02-20 08:00:00	QQQ	ETF	172.21	172.2501	172.11	172.16	25230.0
2019-02-20 08:30:00	QQQ	ETF	172.21	172.45	172.2	172.39	55553.0
2019-02-20 09:00:00	QQQ	ETF	172.39	172.54	172.36	172.45	82179.0
2019-02-20 09:30:00	QQQ	ETF	172.43	172.87	172.35	172.79	1918105.0
2019-02-20 10:00:00	QQQ	ETF	172.79	172.92	172.55	172.89	1506363.0
2019-02-20 10:30:00	QQQ	ETF	172.89	173.08	172.83	172.83	1669632.0
2019-02-20 11:00:00	QQQ	ETF	172.84	172.9	172.66	172.8	1047952.0
2019-02-20 11:30:00	QQQ	ETF	172.805	172.92	172.7093	172.72	963382.0
2019-02-20 12:00:00	QQQ	ETF	172.72	172.77	171.67	171.7	2327113.0
2019-02-20 12:30:00	QQQ	ETF	171.7	171.95	171.46	171.66	2254209.0
2019-02-20 13:00:00	QQQ	ETF	171.66	172.23	171.63	172.22	1573152.0

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

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