PREVIEW / etf_30min / 2017-07-19

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-19.parquet
  size:    432 KB
  rows:    15,010

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-07-19 04:00:00	SPY	ETF	245.91	245.91	245.8	245.8	400.0
2017-07-19 04:30:00	SPY	ETF	245.78	245.83	245.78	245.83	1001.0
2017-07-19 05:00:00	SPY	ETF	245.82	245.85	245.82	245.85	9400.0
2017-07-19 05:30:00	SPY	ETF	245.82	245.85	245.82	245.83	4130.0
2017-07-19 06:00:00	SPY	ETF	245.83	245.83	245.79	245.79	1400.0
2017-07-19 06:30:00	SPY	ETF	245.79	245.79	245.76	245.76	12104.0
2017-07-19 07:00:00	SPY	ETF	245.75	245.8	245.72	245.8	8713.0
2017-07-19 07:30:00	SPY	ETF	245.82	245.82	245.76	245.76	9659.0
2017-07-19 08:00:00	SPY	ETF	245.8	245.98	245.75	245.98	87729.0
2017-07-19 08:30:00	SPY	ETF	245.96	245.97	245.8	245.9	179633.0
2017-07-19 09:00:00	SPY	ETF	245.89	246.08	245.88	246.03	220262.0
2017-07-19 09:30:00	SPY	ETF	246.02	246.39	246.01	246.38	4213048.0
2017-07-19 10:00:00	SPY	ETF	246.38	246.525	246.22	246.31	3479392.0
2017-07-19 10:30:00	SPY	ETF	246.3	246.46	246.14	246.34	2254248.0
2017-07-19 11:00:00	SPY	ETF	246.345	246.48	246.31	246.32	1606233.0
2017-07-19 11:30:00	SPY	ETF	246.33	246.6	246.33	246.52	4910097.0
2017-07-19 12:00:00	SPY	ETF	246.525	246.665	246.525	246.57	4257287.0
2017-07-19 12:30:00	SPY	ETF	246.57	246.62	246.52	246.58	1977307.0
2017-07-19 13:00:00	SPY	ETF	246.58	246.72	246.565	246.68	1354110.0
2017-07-19 13:30:00	SPY	ETF	246.68	246.79	246.64	246.72	1242814.0
2017-07-19 14:00:00	SPY	ETF	246.72	246.835	246.7	246.83	1415818.0
2017-07-19 14:30:00	SPY	ETF	246.82	246.84	246.76	246.79	2044513.0
2017-07-19 15:00:00	SPY	ETF	246.8	246.97	246.77	246.9565	2355753.0
2017-07-19 15:30:00	SPY	ETF	246.96	247.0	246.83	246.99	8242229.0
2017-07-19 16:00:00	SPY	ETF	246.98	247.04	246.94	247.0	7495411.0
2017-07-19 16:30:00	SPY	ETF	247.01	247.04	246.98	246.99	335886.0
2017-07-19 17:00:00	SPY	ETF	246.99	247.02	246.94	246.95	66773.0
2017-07-19 17:30:00	SPY	ETF	246.95	247.0	246.95	246.99	17117.0
2017-07-19 18:00:00	SPY	ETF	246.96	246.96	246.88	246.92	53870.0
2017-07-19 18:30:00	SPY	ETF	246.91	246.92	246.82	246.84	50942.0
2017-07-19 19:00:00	SPY	ETF	246.85	246.86	246.82	246.84	8328.0
2017-07-19 19:30:00	SPY	ETF	246.85	246.92	246.85	246.92	29354.0
2017-07-19 04:00:00	QQQ	ETF	143.51	143.51	143.48	143.48	14511.0
2017-07-19 04:30:00	QQQ	ETF	143.5	143.58	143.5	143.58	1109.0
2017-07-19 05:00:00	QQQ	ETF	143.55	143.56	143.55	143.55	400.0
2017-07-19 05:30:00	QQQ	ETF	143.57	143.6	143.57	143.6	1407.0
2017-07-19 06:00:00	QQQ	ETF	143.56	143.56	143.54	143.54	1400.0
2017-07-19 06:30:00	QQQ	ETF	143.51	143.51	143.47	143.48	2251.0
2017-07-19 07:00:00	QQQ	ETF	143.51	143.53	143.51	143.53	319.0
2017-07-19 07:30:00	QQQ	ETF	143.51	143.52	143.42	143.43	27753.0
2017-07-19 08:00:00	QQQ	ETF	143.44	143.59	143.4	143.59	65913.0
2017-07-19 08:30:00	QQQ	ETF	143.61	143.62	143.53	143.56	43992.0
2017-07-19 09:00:00	QQQ	ETF	143.6	143.72	143.54	143.54	112205.0
2017-07-19 09:30:00	QQQ	ETF	143.53	143.9	143.5	143.7999	4280911.0
2017-07-19 10:00:00	QQQ	ETF	143.79	143.88	143.52	143.73	3531125.0
2017-07-19 10:30:00	QQQ	ETF	143.73	143.79	143.505	143.715	1686521.0
2017-07-19 11:00:00	QQQ	ETF	143.72	143.88	143.7	143.74	953475.0
2017-07-19 11:30:00	QQQ	ETF	143.75	144.01	143.75	144.0	1297830.0
2017-07-19 12:00:00	QQQ	ETF	144.0	144.15	143.98	143.995	1003955.0
2017-07-19 12:30:00	QQQ	ETF	143.99	144.06	143.96	144.03	672952.0

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

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