PREVIEW / etf_30min / 2017-05-23

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-05-23.parquet
  size:    425 KB
  rows:    14,690

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
2017-05-23 04:00:00	SPY	ETF	239.8	240.05	239.8	240.05	22909.0
2017-05-23 04:30:00	SPY	ETF	239.9	239.92	239.86	239.9	4400.0
2017-05-23 05:00:00	SPY	ETF	239.91	239.91	239.86	239.86	5800.0
2017-05-23 05:30:00	SPY	ETF	239.9	239.9	239.76	239.76	2890.0
2017-05-23 06:00:00	SPY	ETF	239.85	239.85	239.8	239.8	1000.0
2017-05-23 06:30:00	SPY	ETF	239.83	239.9	239.83	239.9	61090.0
2017-05-23 07:00:00	SPY	ETF	239.9	240.01	239.85	240.01	90782.0
2017-05-23 07:30:00	SPY	ETF	240.0	240.06	239.92	239.92	251314.0
2017-05-23 08:00:00	SPY	ETF	239.92	240.03	239.85	239.95	104873.0
2017-05-23 08:30:00	SPY	ETF	239.95	239.97	239.87	239.88	99182.0
2017-05-23 09:00:00	SPY	ETF	239.87	239.99	239.86	239.97	141143.0
2017-05-23 09:30:00	SPY	ETF	239.95	240.02	239.57	239.655	4396304.0
2017-05-23 10:00:00	SPY	ETF	239.66	239.895	239.51	239.85	4026886.0
2017-05-23 10:30:00	SPY	ETF	239.86	239.94	239.72	239.88	4177638.0
2017-05-23 11:00:00	SPY	ETF	239.87	240.05	239.84	240.03	2403229.0
2017-05-23 11:30:00	SPY	ETF	240.02	240.15	239.95	240.09	2593056.0
2017-05-23 12:00:00	SPY	ETF	240.09	240.24	239.925	239.94	2555547.0
2017-05-23 12:30:00	SPY	ETF	239.94	240.02	239.82	239.8558	2428551.0
2017-05-23 13:00:00	SPY	ETF	239.85	240.11	239.84	240.05	1544874.0
2017-05-23 13:30:00	SPY	ETF	240.05	240.09	239.91	240.02	1549704.0
2017-05-23 14:00:00	SPY	ETF	240.015	240.06	239.88	239.93	1963326.0
2017-05-23 14:30:00	SPY	ETF	239.94	240.18	239.89	240.12	3347525.0
2017-05-23 15:00:00	SPY	ETF	240.11	240.21	239.97	239.995	3568455.0
2017-05-23 15:30:00	SPY	ETF	239.9975	240.05	239.84	240.02	8869437.0
2017-05-23 16:00:00	SPY	ETF	240.01	240.14	239.9846	240.07	2389149.0
2017-05-23 16:30:00	SPY	ETF	240.07	240.08	239.96	240.01	454279.0
2017-05-23 17:00:00	SPY	ETF	240.0	240.01	239.95	239.95	238457.0
2017-05-23 17:30:00	SPY	ETF	239.95	239.98	239.93	239.98	69022.0
2017-05-23 18:00:00	SPY	ETF	239.98	239.98	239.93	239.97	43089.0
2017-05-23 18:30:00	SPY	ETF	239.96	239.99	239.95	239.97	12429.0
2017-05-23 19:00:00	SPY	ETF	239.96	239.98	239.95	239.98	2195.0
2017-05-23 19:30:00	SPY	ETF	239.97	239.98	239.96	239.97	12467.0
2017-05-23 04:00:00	QQQ	ETF	139.28	139.36	139.28	139.36	1100.0
2017-05-23 04:30:00	QQQ	ETF	139.3	139.3	139.3	139.3	1000.0
2017-05-23 05:30:00	QQQ	ETF	139.21	139.23	139.21	139.23	1377.0
2017-05-23 06:00:00	QQQ	ETF	139.22	139.22	139.21	139.21	300.0
2017-05-23 06:30:00	QQQ	ETF	139.24	139.25	139.24	139.25	700.0
2017-05-23 07:00:00	QQQ	ETF	139.28	139.3	139.27	139.3	14600.0
2017-05-23 07:30:00	QQQ	ETF	139.3	139.4	139.3	139.34	136949.0
2017-05-23 08:00:00	QQQ	ETF	139.28	139.37	139.28	139.37	15329.0
2017-05-23 08:30:00	QQQ	ETF	139.38	139.4	139.31	139.31	7274.0
2017-05-23 09:00:00	QQQ	ETF	139.32	139.44	139.32	139.42	107591.0
2017-05-23 09:30:00	QQQ	ETF	139.42	139.42	138.84	138.9861	2873626.0
2017-05-23 10:00:00	QQQ	ETF	138.9801	139.17	138.896	139.0835	1390589.0
2017-05-23 10:30:00	QQQ	ETF	139.09	139.11	138.91	139.06	824420.0
2017-05-23 11:00:00	QQQ	ETF	139.06	139.2207	139.05	139.2051	650794.0
2017-05-23 11:30:00	QQQ	ETF	139.21	139.24	139.14	139.225	925679.0
2017-05-23 12:00:00	QQQ	ETF	139.22	139.24	138.93	138.9365	737418.0
2017-05-23 12:30:00	QQQ	ETF	138.93	138.99	138.7801	138.8593	1424026.0
2017-05-23 13:00:00	QQQ	ETF	138.86	139.01	138.85	138.97	869311.0

> showing 50 of 14,690 rows — these rows as CSV

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