PREVIEW / etf_30min / 2015-07-28

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-28.parquet
  size:    389 KB
  rows:    13,054

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-07-28 04:00:00	SPY	ETF	207.74	207.97	207.74	207.79	3051.0
2015-07-28 04:30:00	SPY	ETF	207.89	208.16	207.82	208.16	1855.0
2015-07-28 05:00:00	SPY	ETF	208.24	208.24	208.14	208.18	40850.0
2015-07-28 05:30:00	SPY	ETF	208.15	208.39	208.15	208.37	24020.0
2015-07-28 06:00:00	SPY	ETF	208.34	208.41	208.27	208.3	222807.0
2015-07-28 06:30:00	SPY	ETF	208.26	208.29	208.07	208.07	132630.0
2015-07-28 07:00:00	SPY	ETF	208.1	208.13	207.99	208.11	146887.0
2015-07-28 07:30:00	SPY	ETF	208.14	208.18	208.04	208.1	126018.0
2015-07-28 08:00:00	SPY	ETF	208.07	208.25	208.02	208.12	406576.0
2015-07-28 08:30:00	SPY	ETF	208.12	208.16	207.88	208.01	510871.0
2015-07-28 09:00:00	SPY	ETF	208.01	208.01	207.67	207.79	684827.0
2015-07-28 09:30:00	SPY	ETF	207.79	207.84	206.95	207.54	14742053.0
2015-07-28 10:00:00	SPY	ETF	207.54	207.54	206.8	206.9	11762301.0
2015-07-28 10:30:00	SPY	ETF	206.9	207.785	206.87	207.76	9294386.0
2015-07-28 11:00:00	SPY	ETF	207.765	208.04	207.7	208.035	9386018.0
2015-07-28 11:30:00	SPY	ETF	208.04	208.28	208.02	208.24	6328973.0
2015-07-28 12:00:00	SPY	ETF	208.24	208.66	208.23	208.65	7355008.0
2015-07-28 12:30:00	SPY	ETF	208.65	208.69	208.49	208.588	4183493.0
2015-07-28 13:00:00	SPY	ETF	208.58	209.13	208.55	209.04	6498266.0
2015-07-28 13:30:00	SPY	ETF	209.05	209.22	208.84	209.18	4431562.0
2015-07-28 14:00:00	SPY	ETF	209.18	209.5	209.11	209.42	7160919.0
2015-07-28 14:30:00	SPY	ETF	209.42	209.44	209.16	209.4265	6211799.0
2015-07-28 15:00:00	SPY	ETF	209.43	209.44	209.09	209.11	7636034.0
2015-07-28 15:30:00	SPY	ETF	209.11	209.37	209.095	209.3	15136591.0
2015-07-28 16:00:00	SPY	ETF	209.29	209.44	209.08	209.37	5379564.0
2015-07-28 16:30:00	SPY	ETF	209.37	209.53	209.31	209.43	2555542.0
2015-07-28 17:00:00	SPY	ETF	209.43	209.46	209.33	209.44	61866.0
2015-07-28 17:30:00	SPY	ETF	209.44	209.49	209.41	209.42	665747.0
2015-07-28 18:00:00	SPY	ETF	209.41	209.45	209.32	209.43	162954.0
2015-07-28 18:30:00	SPY	ETF	209.44	209.5	209.41	209.47	45412.0
2015-07-28 19:00:00	SPY	ETF	209.47	209.51	209.46	209.48	42348.0
2015-07-28 19:30:00	SPY	ETF	209.5	209.53	209.45	209.5	262775.0
2015-07-28 04:00:00	QQQ	ETF	110.68	110.75	110.64	110.64	619.0
2015-07-28 04:30:00	QQQ	ETF	110.77	110.77	110.77	110.77	6250.0
2015-07-28 05:00:00	QQQ	ETF	110.88	110.88	110.88	110.88	6200.0
2015-07-28 05:30:00	QQQ	ETF	110.97	111.0	110.97	111.0	16350.0
2015-07-28 06:00:00	QQQ	ETF	110.97	111.0	110.91	110.96	9500.0
2015-07-28 06:30:00	QQQ	ETF	110.9	110.9	110.83	110.83	25416.0
2015-07-28 07:00:00	QQQ	ETF	110.83	110.83	110.8	110.82	50400.0
2015-07-28 07:30:00	QQQ	ETF	110.85	110.85	110.79	110.8	3219.0
2015-07-28 08:00:00	QQQ	ETF	110.8	110.9	110.79	110.87	126836.0
2015-07-28 08:30:00	QQQ	ETF	110.86	110.86	110.73	110.78	47537.0
2015-07-28 09:00:00	QQQ	ETF	110.8	110.8	110.58	110.67	133832.0
2015-07-28 09:30:00	QQQ	ETF	110.67	110.69	109.88	110.39	5278118.0
2015-07-28 10:00:00	QQQ	ETF	110.4	110.42	109.785	109.85	5345316.0
2015-07-28 10:30:00	QQQ	ETF	109.845	110.32	109.82	110.3	4094917.0
2015-07-28 11:00:00	QQQ	ETF	110.3	110.4426	110.22	110.42	2107573.0
2015-07-28 11:30:00	QQQ	ETF	110.43	110.6	110.41	110.59	1250990.0
2015-07-28 12:00:00	QQQ	ETF	110.59	110.869	110.581	110.855	1083406.0
2015-07-28 12:30:00	QQQ	ETF	110.86	110.87	110.7	110.72	897559.0

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

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