PREVIEW / etf_30min / 2015-06-30

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-30.parquet
  size:    396 KB
  rows:    13,520

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
2015-06-30 04:00:00	SPY	ETF	206.1	206.2	206.1	206.1	2000.0
2015-06-30 04:30:00	SPY	ETF	206.08	206.29	205.95	206.28	19123.0
2015-06-30 05:00:00	SPY	ETF	206.2	207.39	206.2	207.27	154314.0
2015-06-30 05:30:00	SPY	ETF	207.15	207.23	206.79	206.99	76615.0
2015-06-30 06:00:00	SPY	ETF	206.99	207.29	206.77	206.8	129537.0
2015-06-30 06:30:00	SPY	ETF	206.8	207.04	206.48	206.72	141591.0
2015-06-30 07:00:00	SPY	ETF	206.68	206.86	206.52	206.57	166525.0
2015-06-30 07:30:00	SPY	ETF	206.55	206.97	206.53	206.86	596327.0
2015-06-30 08:00:00	SPY	ETF	206.85	207.27	206.18	206.97	2102199.0
2015-06-30 08:30:00	SPY	ETF	206.95	207.14	206.86	207.14	645737.0
2015-06-30 09:00:00	SPY	ETF	207.14	207.39	206.85	207.26	2706226.0
2015-06-30 09:30:00	SPY	ETF	207.26	207.32	206.13	206.15	18031098.0
2015-06-30 10:00:00	SPY	ETF	206.15	206.44	205.88	206.4	10362628.0
2015-06-30 10:30:00	SPY	ETF	206.39	206.4	205.65	206.15	10489115.0
2015-06-30 11:00:00	SPY	ETF	206.15	206.53	206.02	206.05	9208393.0
2015-06-30 11:30:00	SPY	ETF	206.05	206.17	205.74	205.75	10116386.0
2015-06-30 12:00:00	SPY	ETF	205.75	206.07	205.37	205.44	8297023.0
2015-06-30 12:30:00	SPY	ETF	205.44	205.79	205.28	205.78	7714470.0
2015-06-30 13:00:00	SPY	ETF	205.78	206.085	205.635	206.04	5844731.0
2015-06-30 13:30:00	SPY	ETF	206.04	206.72	205.98	206.47	11589139.0
2015-06-30 14:00:00	SPY	ETF	206.46	207.16	206.42	206.67	12984877.0
2015-06-30 14:30:00	SPY	ETF	206.665	206.88	206.21	206.23	7475312.0
2015-06-30 15:00:00	SPY	ETF	206.2355	206.44	205.87	206.04	10706519.0
2015-06-30 15:30:00	SPY	ETF	206.05	206.54	205.88	205.89	22542778.0
2015-06-30 16:00:00	SPY	ETF	205.91	206.3173	205.58	206.03	11845822.0
2015-06-30 16:30:00	SPY	ETF	206.04	206.6015	205.4658	206.25	14314802.0
2015-06-30 17:00:00	SPY	ETF	206.25	206.35	205.85	206.29	1096168.0
2015-06-30 17:30:00	SPY	ETF	206.25	206.29	206.15	206.24	69038.0
2015-06-30 18:00:00	SPY	ETF	206.24	206.3	206.2	206.29	76821.0
2015-06-30 18:30:00	SPY	ETF	206.29	206.29	206.09	206.12	44455.0
2015-06-30 19:00:00	SPY	ETF	206.18	206.19	206.11	206.11	15986.0
2015-06-30 05:00:00	QQQ	ETF	107.06	107.37	107.06	107.37	12350.0
2015-06-30 05:30:00	QQQ	ETF	107.4	107.44	107.4	107.44	500.0
2015-06-30 06:00:00	QQQ	ETF	107.42	107.43	107.35	107.35	400.0
2015-06-30 06:30:00	QQQ	ETF	107.33	107.41	107.21	107.27	24000.0
2015-06-30 07:00:00	QQQ	ETF	107.27	107.27	107.22	107.23	6951.0
2015-06-30 07:30:00	QQQ	ETF	107.22	107.4	107.22	107.35	20999.0
2015-06-30 08:00:00	QQQ	ETF	107.34	107.55	107.29	107.43	183632.0
2015-06-30 08:30:00	QQQ	ETF	107.42	107.5	107.38	107.48	59510.0
2015-06-30 09:00:00	QQQ	ETF	107.48	107.58	107.37	107.5	435132.0
2015-06-30 09:30:00	QQQ	ETF	107.49	107.51	107.05	107.061	4582028.0
2015-06-30 10:00:00	QQQ	ETF	107.06	107.2796	106.95	107.24	2641381.0
2015-06-30 10:30:00	QQQ	ETF	107.25	107.25	106.81	107.12	1696241.0
2015-06-30 11:00:00	QQQ	ETF	107.12	107.3799	107.08	107.13	1585688.0
2015-06-30 11:30:00	QQQ	ETF	107.135	107.22	106.991	107.0	1554928.0
2015-06-30 12:00:00	QQQ	ETF	107.0	107.17	106.79	106.82	1360089.0
2015-06-30 12:30:00	QQQ	ETF	106.831	106.96	106.74	106.96	1097002.0
2015-06-30 13:00:00	QQQ	ETF	106.96	107.11	106.84	107.11	913609.0
2015-06-30 13:30:00	QQQ	ETF	107.1	107.52	107.06	107.405	2356611.0
2015-06-30 14:00:00	QQQ	ETF	107.4	107.72	107.37	107.43	2587147.0

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

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