PREVIEW / etf_30min / 2017-10-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-19.parquet
  size:    448 KB
  rows:    15,439

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-10-19 04:00:00	SPY	ETF	254.57	254.68	254.0	254.46	77596.0
2017-10-19 04:30:00	SPY	ETF	254.51	254.86	254.51	254.78	58135.0
2017-10-19 05:00:00	SPY	ETF	254.78	254.88	254.68	254.85	34850.0
2017-10-19 05:30:00	SPY	ETF	254.9	254.92	254.7	254.74	52584.0
2017-10-19 06:00:00	SPY	ETF	254.73	254.8	254.63	254.77	46087.0
2017-10-19 06:30:00	SPY	ETF	254.7	254.74	254.39	254.54	302528.0
2017-10-19 07:00:00	SPY	ETF	254.54	254.68	254.23	254.65	396275.0
2017-10-19 07:30:00	SPY	ETF	254.66	254.74	254.6	254.63	101761.0
2017-10-19 08:00:00	SPY	ETF	254.32	255.72	254.32	254.47	211512.0
2017-10-19 08:30:00	SPY	ETF	254.47	254.85	254.47	254.85	617071.0
2017-10-19 09:00:00	SPY	ETF	254.85	254.85	254.75	254.81	267786.0
2017-10-19 09:30:00	SPY	ETF	254.83	255.26	254.46	254.57	7489756.0
2017-10-19 10:00:00	SPY	ETF	254.57	254.86	254.35	254.85	5225594.0
2017-10-19 10:30:00	SPY	ETF	254.85	255.18	254.67	255.1745	3669534.0
2017-10-19 11:00:00	SPY	ETF	255.17	255.23	255.06	255.105	2756816.0
2017-10-19 11:30:00	SPY	ETF	255.105	255.23	255.03	255.08	4316520.0
2017-10-19 12:00:00	SPY	ETF	255.08	255.25	254.97	255.245	2325501.0
2017-10-19 12:30:00	SPY	ETF	255.25	255.255	255.09	255.23	2416893.0
2017-10-19 13:00:00	SPY	ETF	255.24	255.44	255.22	255.42	2470457.0
2017-10-19 13:30:00	SPY	ETF	255.42	255.56	255.365	255.42	1663257.0
2017-10-19 14:00:00	SPY	ETF	255.43	255.505	255.39	255.39	3231123.0
2017-10-19 14:30:00	SPY	ETF	255.4	255.64	255.4	255.56	2525296.0
2017-10-19 15:00:00	SPY	ETF	255.56	255.66	255.525	255.62	2824622.0
2017-10-19 15:30:00	SPY	ETF	255.62	255.82	255.46	255.82	10007890.0
2017-10-19 16:00:00	SPY	ETF	255.81	255.91	255.7682	255.83	4448220.0
2017-10-19 16:30:00	SPY	ETF	255.86	255.92	255.79	255.88	1664906.0
2017-10-19 17:00:00	SPY	ETF	255.85	255.91	255.79	255.88	1448286.0
2017-10-19 17:30:00	SPY	ETF	255.89	255.91	255.88	255.89	12061.0
2017-10-19 18:00:00	SPY	ETF	255.88	255.9	255.82	255.84	114787.0
2017-10-19 18:30:00	SPY	ETF	255.84	255.85	255.82	255.83	22354.0
2017-10-19 19:00:00	SPY	ETF	255.83	255.83	255.76	255.78	218242.0
2017-10-19 19:30:00	SPY	ETF	255.81	255.87	255.81	255.85	13531.0
2017-10-19 04:00:00	QQQ	ETF	147.75	147.86	147.43	147.7	34119.0
2017-10-19 04:30:00	QQQ	ETF	147.78	148.06	147.77	148.05	16300.0
2017-10-19 05:00:00	QQQ	ETF	147.99	148.16	147.94	148.16	23015.0
2017-10-19 05:30:00	QQQ	ETF	148.16	148.16	148.05	148.05	10500.0
2017-10-19 06:00:00	QQQ	ETF	148.09	148.09	147.97	148.09	10387.0
2017-10-19 06:30:00	QQQ	ETF	148.04	148.07	147.71	147.86	80560.0
2017-10-19 07:00:00	QQQ	ETF	147.83	147.92	147.7	147.88	168284.0
2017-10-19 07:30:00	QQQ	ETF	147.95	147.97	147.87	147.93	136060.0
2017-10-19 08:00:00	QQQ	ETF	147.87	148.05	147.75	147.86	91172.0
2017-10-19 08:30:00	QQQ	ETF	147.91	148.86	147.91	148.09	182953.0
2017-10-19 09:00:00	QQQ	ETF	148.08	148.12	148.0	148.04	78317.0
2017-10-19 09:30:00	QQQ	ETF	148.02	148.26	147.31	147.53	5355155.0
2017-10-19 10:00:00	QQQ	ETF	147.52	147.83	147.27	147.76	3780407.0
2017-10-19 10:30:00	QQQ	ETF	147.77	148.01	147.58	148.008	1703093.0
2017-10-19 11:00:00	QQQ	ETF	148.0	148.08	147.95	147.9572	1147785.0
2017-10-19 11:30:00	QQQ	ETF	147.96	148.15	147.78	147.83	1109895.0
2017-10-19 12:00:00	QQQ	ETF	147.835	147.925	147.695	147.89	1222931.0
2017-10-19 12:30:00	QQQ	ETF	147.89	147.89	147.73	147.84	778154.0

> showing 50 of 15,439 rows — these rows as CSV

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