PREVIEW / etf_30min / 2016-03-29

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-29.parquet
  size:    398 KB
  rows:    13,351

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-03-29 04:00:00	SPY	ETF	203.55	203.67	203.42	203.56	4477.0
2016-03-29 04:30:00	SPY	ETF	203.57	203.69	203.45	203.55	53426.0
2016-03-29 05:00:00	SPY	ETF	203.56	203.56	203.05	203.05	42381.0
2016-03-29 05:30:00	SPY	ETF	203.04	203.12	202.83	202.94	23383.0
2016-03-29 06:00:00	SPY	ETF	202.94	203.04	202.8	203.02	19212.0
2016-03-29 06:30:00	SPY	ETF	202.99	203.02	202.7	202.74	85184.0
2016-03-29 07:00:00	SPY	ETF	202.76	202.81	202.55	202.66	100990.0
2016-03-29 07:30:00	SPY	ETF	202.63	202.83	202.58	202.78	148427.0
2016-03-29 08:00:00	SPY	ETF	202.82	203.55	202.58	202.73	224946.0
2016-03-29 08:30:00	SPY	ETF	202.72	202.77	202.58	202.72	225867.0
2016-03-29 09:00:00	SPY	ETF	202.72	202.89	202.59	202.78	337612.0
2016-03-29 09:30:00	SPY	ETF	202.76	202.85	202.4	202.8	6940315.0
2016-03-29 10:00:00	SPY	ETF	202.8	203.13	202.8	202.9	5479154.0
2016-03-29 10:30:00	SPY	ETF	202.92	203.07	202.8	202.975	4606320.0
2016-03-29 11:00:00	SPY	ETF	202.98	203.16	202.86	203.06	3945324.0
2016-03-29 11:30:00	SPY	ETF	203.055	203.28	202.95	203.125	3980343.0
2016-03-29 12:00:00	SPY	ETF	203.125	204.12	203.06	204.0575	8249765.0
2016-03-29 12:30:00	SPY	ETF	204.05	204.44	203.97	204.13	8927988.0
2016-03-29 13:00:00	SPY	ETF	204.13	204.23	203.835	204.1	5757829.0
2016-03-29 13:30:00	SPY	ETF	204.09	204.39	203.97	204.32	3978027.0
2016-03-29 14:00:00	SPY	ETF	204.31	204.97	204.28	204.95	6948911.0
2016-03-29 14:30:00	SPY	ETF	204.94	205.09	204.81	204.89	5636905.0
2016-03-29 15:00:00	SPY	ETF	204.9	205.21	204.82	205.2	6717969.0
2016-03-29 15:30:00	SPY	ETF	205.195	205.2	204.87	205.15	13285972.0
2016-03-29 16:00:00	SPY	ETF	205.16	205.26	204.313	205.22	3220936.0
2016-03-29 16:30:00	SPY	ETF	205.21	205.38	205.21	205.33	392048.0
2016-03-29 17:00:00	SPY	ETF	205.33	205.35	205.12	205.31	171822.0
2016-03-29 17:30:00	SPY	ETF	205.32	205.34	205.31	205.32	26563.0
2016-03-29 18:00:00	SPY	ETF	205.31	205.37	205.23	205.25	121426.0
2016-03-29 18:30:00	SPY	ETF	205.26	205.27	205.18	205.26	40885.0
2016-03-29 19:00:00	SPY	ETF	205.26	205.5	205.26	205.44	140904.0
2016-03-29 19:30:00	SPY	ETF	205.42	205.54	205.42	205.5	47212.0
2016-03-29 05:30:00	QQQ	ETF	106.98	107.04	106.92	106.92	1098.0
2016-03-29 06:00:00	QQQ	ETF	106.97	106.97	106.96	106.97	699.0
2016-03-29 06:30:00	QQQ	ETF	107.02	107.02	106.97	106.97	600.0
2016-03-29 07:00:00	QQQ	ETF	106.82	106.84	106.79	106.81	20905.0
2016-03-29 07:30:00	QQQ	ETF	106.83	106.93	106.83	106.93	11350.0
2016-03-29 08:00:00	QQQ	ETF	106.9	106.95	106.89	106.9	20453.0
2016-03-29 08:30:00	QQQ	ETF	106.9	106.92	106.83	106.9	5850.0
2016-03-29 09:00:00	QQQ	ETF	106.87	106.96	106.82	106.92	64347.0
2016-03-29 09:30:00	QQQ	ETF	106.93	107.04	106.735	106.97	1967226.0
2016-03-29 10:00:00	QQQ	ETF	106.98	107.29	106.98	107.23	1503611.0
2016-03-29 10:30:00	QQQ	ETF	107.23	107.48	107.23	107.41	1120855.0
2016-03-29 11:00:00	QQQ	ETF	107.42	107.6	107.39	107.57	1141367.0
2016-03-29 11:30:00	QQQ	ETF	107.56	107.71	107.43	107.62	955365.0
2016-03-29 12:00:00	QQQ	ETF	107.61	108.09	107.55	108.05	1934759.0
2016-03-29 12:30:00	QQQ	ETF	108.05	108.34	108.05	108.18	2432441.0
2016-03-29 13:00:00	QQQ	ETF	108.2	108.38	108.07	108.285	1718390.0
2016-03-29 13:30:00	QQQ	ETF	108.27	108.45	108.18	108.39	1281094.0
2016-03-29 14:00:00	QQQ	ETF	108.387	108.82	108.37	108.77	2198937.0

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

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