PREVIEW / etf_30min / 2019-03-07

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-07.parquet
  size:    496 KB
  rows:    17,727

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-03-07 04:00:00	SPY	ETF	276.65	276.7	276.56	276.67	17537.0
2019-03-07 04:30:00	SPY	ETF	276.65	276.74	276.62	276.62	8824.0
2019-03-07 05:00:00	SPY	ETF	276.78	276.78	276.59	276.67	2810.0
2019-03-07 05:30:00	SPY	ETF	276.64	276.76	276.64	276.76	11560.0
2019-03-07 06:00:00	SPY	ETF	276.71	276.78	276.68	276.78	7250.0
2019-03-07 06:30:00	SPY	ETF	276.78	276.78	276.57	276.65	56579.0
2019-03-07 07:00:00	SPY	ETF	276.63	276.99	276.62	276.9	101834.0
2019-03-07 07:30:00	SPY	ETF	276.92	277.49	276.85	277.48	407213.0
2019-03-07 08:00:00	SPY	ETF	277.51	277.72	276.62	277.61	343221.0
2019-03-07 08:30:00	SPY	ETF	277.6	277.8	277.0	277.1	516486.0
2019-03-07 09:00:00	SPY	ETF	277.12	277.33	276.77	276.8	341595.0
2019-03-07 09:30:00	SPY	ETF	276.83	276.99	274.73	275.29	13710497.0
2019-03-07 10:00:00	SPY	ETF	275.27	275.37	274.36	275.06	9212103.0
2019-03-07 10:30:00	SPY	ETF	275.0549	275.48	274.6397	275.29	6692119.0
2019-03-07 11:00:00	SPY	ETF	275.29	275.4	274.82	275.35	4975833.0
2019-03-07 11:30:00	SPY	ETF	275.35	275.89	275.35	275.51	4944098.0
2019-03-07 12:00:00	SPY	ETF	275.51	275.71	275.25	275.54	4950473.0
2019-03-07 12:30:00	SPY	ETF	275.54	276.3	275.08	276.17	4950134.0
2019-03-07 13:00:00	SPY	ETF	276.165	276.21	275.8	275.93	2162041.0
2019-03-07 13:30:00	SPY	ETF	275.93	275.97	275.48	275.53	2472903.0
2019-03-07 14:00:00	SPY	ETF	275.53	275.71	274.9	275.16	4789318.0
2019-03-07 14:30:00	SPY	ETF	275.165	275.24	274.25	274.41	5772106.0
2019-03-07 15:00:00	SPY	ETF	274.42	274.93	274.07	274.41	7506219.0
2019-03-07 15:30:00	SPY	ETF	274.41	275.18	274.4	275.08	12525120.0
2019-03-07 16:00:00	SPY	ETF	275.08	275.4	274.7524	275.15	5998919.0
2019-03-07 16:30:00	SPY	ETF	275.16	275.25	275.11	275.16	296645.0
2019-03-07 17:00:00	SPY	ETF	275.16	275.23	275.0805	275.1	126131.0
2019-03-07 17:30:00	SPY	ETF	275.1	275.1	275.06	275.1	22827.0
2019-03-07 18:00:00	SPY	ETF	275.08	275.13	275.01	275.12	13590.0
2019-03-07 18:30:00	SPY	ETF	275.11	275.29	275.08	275.29	28956.0
2019-03-07 19:00:00	SPY	ETF	275.29	275.3	274.99	275.14	105886.0
2019-03-07 19:30:00	SPY	ETF	275.22	275.22	274.73	274.73	28293.0
2019-03-07 04:00:00	QQQ	ETF	172.9	172.96	172.88	172.88	1485.0
2019-03-07 04:30:00	QQQ	ETF	172.94	172.97	172.91	172.91	2000.0
2019-03-07 05:00:00	QQQ	ETF	172.98	173.02	172.98	173.02	1300.0
2019-03-07 05:30:00	QQQ	ETF	172.98	173.03	172.98	173.01	26050.0
2019-03-07 06:00:00	QQQ	ETF	173.03	173.09	173.02	173.06	4000.0
2019-03-07 06:30:00	QQQ	ETF	173.07	173.07	172.92	172.94	3000.0
2019-03-07 07:00:00	QQQ	ETF	172.87	173.15	172.87	173.08	34031.0
2019-03-07 07:30:00	QQQ	ETF	173.07	173.41	173.0	173.41	75132.0
2019-03-07 08:00:00	QQQ	ETF	173.43	173.62	172.79	173.53	131175.0
2019-03-07 08:30:00	QQQ	ETF	173.49	173.7	173.2	173.28	154110.0
2019-03-07 09:00:00	QQQ	ETF	173.28	173.48	173.01	173.11	205300.0
2019-03-07 09:30:00	QQQ	ETF	173.09	173.18	171.64	171.94	6518156.0
2019-03-07 10:00:00	QQQ	ETF	171.93	172.03	171.31	171.76	4159087.0
2019-03-07 10:30:00	QQQ	ETF	171.76	172.01	171.34	171.91	2938471.0
2019-03-07 11:00:00	QQQ	ETF	171.895	172.1	171.67	172.01	1761336.0
2019-03-07 11:30:00	QQQ	ETF	172.03	172.4911	172.03	172.26	1853207.0
2019-03-07 12:00:00	QQQ	ETF	172.26	172.47	172.11	172.32	1445163.0
2019-03-07 12:30:00	QQQ	ETF	172.32	172.67	171.9299	172.58	2274978.0

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

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