PREVIEW / etf_30min / 2014-01-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-21.parquet
  size:    349 KB
  rows:    11,765

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
2014-01-21 04:00:00	SPY	ETF	184.15	184.3	184.15	184.29	79381.0
2014-01-21 04:30:00	SPY	ETF	184.25	184.25	184.13	184.15	29169.0
2014-01-21 05:00:00	SPY	ETF	184.12	184.27	184.12	184.26	23162.0
2014-01-21 05:30:00	SPY	ETF	184.29	184.35	184.21	184.26	7195.0
2014-01-21 06:00:00	SPY	ETF	184.27	184.39	184.27	184.39	62132.0
2014-01-21 06:30:00	SPY	ETF	184.39	184.4	184.29	184.3	36609.0
2014-01-21 07:00:00	SPY	ETF	184.34	184.34	184.24	184.28	27803.0
2014-01-21 07:30:00	SPY	ETF	184.29	184.47	184.25	184.39	168871.0
2014-01-21 08:00:00	SPY	ETF	184.39	184.72	183.63	184.45	196255.0
2014-01-21 08:30:00	SPY	ETF	184.45	184.575	184.45	184.57	310869.0
2014-01-21 09:00:00	SPY	ETF	184.54	184.74	184.54	184.69	808708.0
2014-01-21 09:30:00	SPY	ETF	184.7	184.77	184.5	184.59	9281598.0
2014-01-21 10:00:00	SPY	ETF	184.58	184.62	183.91	184.02	9040412.0
2014-01-21 10:30:00	SPY	ETF	184.02	184.04	183.83	184.01	4423474.0
2014-01-21 11:00:00	SPY	ETF	184.01	184.07	183.09	183.34	9908166.0
2014-01-21 11:30:00	SPY	ETF	183.349	183.46	183.19	183.36	5428577.0
2014-01-21 12:00:00	SPY	ETF	183.36	183.64	183.05	183.58	6709081.0
2014-01-21 12:30:00	SPY	ETF	183.58	183.74	183.57	183.74	2922697.0
2014-01-21 13:00:00	SPY	ETF	183.74	183.899	183.73	183.849	2435684.0
2014-01-21 13:30:00	SPY	ETF	183.85	184.195	183.85	184.05	4618164.0
2014-01-21 14:00:00	SPY	ETF	184.05	184.1399	183.955	184.0	2665890.0
2014-01-21 14:30:00	SPY	ETF	183.99	184.24	183.91	184.06	4389841.0
2014-01-21 15:00:00	SPY	ETF	184.06	184.12	183.89	183.9499	5012108.0
2014-01-21 15:30:00	SPY	ETF	183.94	184.23	183.915	184.19	11088042.0
2014-01-21 16:00:00	SPY	ETF	184.19	184.29	184.07	184.14	4335489.0
2014-01-21 16:30:00	SPY	ETF	184.16	184.19	183.695	183.695	3494512.0
2014-01-21 17:00:00	SPY	ETF	184.11	184.15	184.09	184.11	43020.0
2014-01-21 17:30:00	SPY	ETF	184.12	184.12	184.1	184.12	8600.0
2014-01-21 18:00:00	SPY	ETF	184.13	184.13	184.02	184.04	33922.0
2014-01-21 18:30:00	SPY	ETF	184.05	184.05	184.02	184.05	8920.0
2014-01-21 19:00:00	SPY	ETF	184.05	184.1	184.05	184.1	5778.0
2014-01-21 19:30:00	SPY	ETF	184.12	184.14	184.11	184.14	23440.0
2014-01-21 04:00:00	QQQ	ETF	88.24	88.33	88.01	88.33	3000.0
2014-01-21 04:30:00	QQQ	ETF	88.25	88.25	88.25	88.25	300.0
2014-01-21 05:30:00	QQQ	ETF	88.31	88.31	88.28	88.28	400.0
2014-01-21 06:00:00	QQQ	ETF	88.32	88.37	88.32	88.37	2600.0
2014-01-21 06:30:00	QQQ	ETF	88.39	88.4	88.37	88.38	11540.0
2014-01-21 07:00:00	QQQ	ETF	88.33	88.36	88.31	88.32	4546.0
2014-01-21 07:30:00	QQQ	ETF	88.33	88.41	88.32	88.39	105335.0
2014-01-21 08:00:00	QQQ	ETF	88.36	88.4	88.36	88.37	56375.0
2014-01-21 08:30:00	QQQ	ETF	88.38	88.4	88.35	88.39	42328.0
2014-01-21 09:00:00	QQQ	ETF	88.39	88.45	88.39	88.43	95429.0
2014-01-21 09:30:00	QQQ	ETF	88.44	88.59	88.39	88.54	4233714.0
2014-01-21 10:00:00	QQQ	ETF	88.53	88.55	88.191	88.27	3349322.0
2014-01-21 10:30:00	QQQ	ETF	88.27	88.275	88.12	88.27	1739661.0
2014-01-21 11:00:00	QQQ	ETF	88.265	88.3	87.81	87.99	2467271.0
2014-01-21 11:30:00	QQQ	ETF	87.99	88.09	87.93	88.08	1303312.0
2014-01-21 12:00:00	QQQ	ETF	88.08	88.21	87.91	88.19	1319215.0
2014-01-21 12:30:00	QQQ	ETF	88.2	88.3	88.18	88.29	588025.0
2014-01-21 13:00:00	QQQ	ETF	88.2874	88.38	88.27	88.3351	753596.0

> showing 50 of 11,765 rows — these rows as CSV

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