PREVIEW / etf_30min / 2016-01-06

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-01-06.parquet
  size:    406 KB
  rows:    13,714

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
2016-01-06 04:00:00	SPY	ETF	199.52	199.85	199.37	199.74	202593.0
2016-01-06 04:30:00	SPY	ETF	199.75	199.75	199.35	199.53	79515.0
2016-01-06 05:00:00	SPY	ETF	199.5	199.59	198.83	198.83	123120.0
2016-01-06 05:30:00	SPY	ETF	198.84	199.04	198.75	198.79	40151.0
2016-01-06 06:00:00	SPY	ETF	198.79	198.79	198.06	198.53	115867.0
2016-01-06 06:30:00	SPY	ETF	198.58	198.84	198.43	198.8	140650.0
2016-01-06 07:00:00	SPY	ETF	198.8	198.83	198.5	198.64	513838.0
2016-01-06 07:30:00	SPY	ETF	198.59	198.6	197.87	197.97	580889.0
2016-01-06 08:00:00	SPY	ETF	197.97	199.11	197.75	198.31	1565724.0
2016-01-06 08:30:00	SPY	ETF	198.34	198.42	198.04	198.38	687321.0
2016-01-06 09:00:00	SPY	ETF	198.38	201.35	197.98	198.34	1216468.0
2016-01-06 09:30:00	SPY	ETF	198.34	199.31	198.26	199.2	18956575.0
2016-01-06 10:00:00	SPY	ETF	199.18	199.69	198.73	199.63	10663170.0
2016-01-06 10:30:00	SPY	ETF	199.63	199.63	198.81	199.26	10982646.0
2016-01-06 11:00:00	SPY	ETF	199.25	200.06	199.21	199.81	8453580.0
2016-01-06 11:30:00	SPY	ETF	199.82	200.01	199.27	199.32	5512544.0
2016-01-06 12:00:00	SPY	ETF	199.32	199.36	199.06	199.18	4235290.0
2016-01-06 12:30:00	SPY	ETF	199.18	199.73	199.09	199.23	4248154.0
2016-01-06 13:00:00	SPY	ETF	199.235	199.32	198.79	198.95	4972116.0
2016-01-06 13:30:00	SPY	ETF	198.955	199.15	198.68	198.731	3540937.0
2016-01-06 14:00:00	SPY	ETF	198.73	199.34	198.58	198.99	8791664.0
2016-01-06 14:30:00	SPY	ETF	199.0	199.08	197.65	197.75	13902303.0
2016-01-06 15:00:00	SPY	ETF	197.75	198.59	197.6	198.5	12807496.0
2016-01-06 15:30:00	SPY	ETF	198.5	198.93	198.25	198.79	23413015.0
2016-01-06 16:00:00	SPY	ETF	198.79	199.24	198.484	199.03	13614908.0
2016-01-06 16:30:00	SPY	ETF	199.05	199.27	199.04	199.16	776545.0
2016-01-06 17:00:00	SPY	ETF	199.2	199.26	199.2	199.25	175026.0
2016-01-06 17:30:00	SPY	ETF	199.26	199.28	199.24	199.28	83724.0
2016-01-06 18:00:00	SPY	ETF	199.28	199.28	199.1	199.18	173248.0
2016-01-06 18:30:00	SPY	ETF	199.18	199.45	198.85	199.44	42622.0
2016-01-06 19:00:00	SPY	ETF	199.44	199.56	199.31	199.34	91110.0
2016-01-06 19:30:00	SPY	ETF	199.36	199.4	199.24	199.29	98135.0
2016-01-06 04:00:00	QQQ	ETF	108.33	108.35	108.14	108.31	2660.0
2016-01-06 04:30:00	QQQ	ETF	108.24	108.28	108.09	108.16	19300.0
2016-01-06 05:00:00	QQQ	ETF	108.1	108.1	107.67	107.67	2610.0
2016-01-06 05:30:00	QQQ	ETF	107.73	107.81	107.7	107.7	800.0
2016-01-06 06:00:00	QQQ	ETF	107.67	107.67	107.4	107.54	13308.0
2016-01-06 06:30:00	QQQ	ETF	107.52	107.62	107.43	107.56	29100.0
2016-01-06 07:00:00	QQQ	ETF	107.54	107.59	107.48	107.51	32623.0
2016-01-06 07:30:00	QQQ	ETF	107.49	107.5	107.13	107.17	69401.0
2016-01-06 08:00:00	QQQ	ETF	107.17	107.54	107.1	107.32	179016.0
2016-01-06 08:30:00	QQQ	ETF	107.35	109.31	107.21	109.31	55267.0
2016-01-06 09:00:00	QQQ	ETF	107.41	107.46	107.23	107.45	241814.0
2016-01-06 09:30:00	QQQ	ETF	107.44	108.22	107.41	108.1768	6013108.0
2016-01-06 10:00:00	QQQ	ETF	108.16	108.65	107.86	108.61	2877271.0
2016-01-06 10:30:00	QQQ	ETF	108.6	108.61	108.16	108.51	2235694.0
2016-01-06 11:00:00	QQQ	ETF	108.49	108.89	108.335	108.76	2164685.0
2016-01-06 11:30:00	QQQ	ETF	108.76	108.87	108.51	108.52	1519967.0
2016-01-06 12:00:00	QQQ	ETF	108.53	108.58	108.29	108.35	780653.0
2016-01-06 12:30:00	QQQ	ETF	108.34	108.66	108.285	108.361	1522990.0

> showing 50 of 13,714 rows — these rows as CSV

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