PREVIEW / etf_30min / 2015-02-13

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-02-13.parquet
  size:    376 KB
  rows:    12,770

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-02-13 04:00:00	SPY	ETF	209.1	209.44	208.92	209.21	8587.0
2015-02-13 04:30:00	SPY	ETF	209.21	209.35	209.2	209.34	5950.0
2015-02-13 05:00:00	SPY	ETF	209.28	209.31	209.23	209.27	7600.0
2015-02-13 05:30:00	SPY	ETF	209.31	209.34	209.31	209.34	700.0
2015-02-13 06:00:00	SPY	ETF	209.28	209.28	209.2	209.2	600.0
2015-02-13 06:30:00	SPY	ETF	209.16	209.22	209.12	209.22	7600.0
2015-02-13 07:00:00	SPY	ETF	209.17	209.26	209.1	209.18	68265.0
2015-02-13 07:30:00	SPY	ETF	209.21	209.29	209.17	209.2	67121.0
2015-02-13 08:00:00	SPY	ETF	209.17	209.33	209.14	209.27	155867.0
2015-02-13 08:30:00	SPY	ETF	209.27	209.36	209.23	209.3	314153.0
2015-02-13 09:00:00	SPY	ETF	209.32	209.32	208.92	209.06	1098358.0
2015-02-13 09:30:00	SPY	ETF	209.07	209.48	208.98	209.437	10897396.0
2015-02-13 10:00:00	SPY	ETF	209.42	209.55	209.07	209.45	8870218.0
2015-02-13 10:30:00	SPY	ETF	209.46	209.51	209.195	209.385	4415612.0
2015-02-13 11:00:00	SPY	ETF	209.39	209.6648	209.39	209.51	4543870.0
2015-02-13 11:30:00	SPY	ETF	209.51	209.625	209.33	209.55	3837303.0
2015-02-13 12:00:00	SPY	ETF	209.5457	209.59	209.3	209.31	2532041.0
2015-02-13 12:30:00	SPY	ETF	209.31	209.38	209.215	209.25	2287897.0
2015-02-13 13:00:00	SPY	ETF	209.25	209.4	209.1	209.11	5372031.0
2015-02-13 13:30:00	SPY	ETF	209.1	209.12	208.76	209.015	5952911.0
2015-02-13 14:00:00	SPY	ETF	209.02	209.38	208.96	209.28	4785579.0
2015-02-13 14:30:00	SPY	ETF	209.285	209.37	209.16	209.345	4105032.0
2015-02-13 15:00:00	SPY	ETF	209.345	209.66	209.265	209.61	6366035.0
2015-02-13 15:30:00	SPY	ETF	209.605	209.84	209.45	209.8	13146812.0
2015-02-13 16:00:00	SPY	ETF	209.81	209.9	209.2932	209.72	5648445.0
2015-02-13 16:30:00	SPY	ETF	209.73	209.91	209.1373	209.86	7990619.0
2015-02-13 17:00:00	SPY	ETF	209.9	209.95	209.88	209.92	276139.0
2015-02-13 17:30:00	SPY	ETF	209.93	209.97	209.91	209.95	68794.0
2015-02-13 18:00:00	SPY	ETF	209.96	209.96	209.92	209.93	19383.0
2015-02-13 18:30:00	SPY	ETF	209.93	209.95	209.92	209.93	11080.0
2015-02-13 19:00:00	SPY	ETF	209.92	209.94	209.91	209.91	5578.0
2015-02-13 19:30:00	SPY	ETF	209.92	209.97	209.9	209.97	29988.0
2015-02-13 04:00:00	QQQ	ETF	106.2	106.36	106.2	106.36	13000.0
2015-02-13 05:00:00	QQQ	ETF	106.34	106.42	106.34	106.42	5422.0
2015-02-13 06:00:00	QQQ	ETF	106.27	106.27	106.27	106.27	500.0
2015-02-13 06:30:00	QQQ	ETF	106.3	106.3	106.21	106.21	600.0
2015-02-13 07:00:00	QQQ	ETF	106.29	106.29	106.24	106.29	3800.0
2015-02-13 07:30:00	QQQ	ETF	106.3	106.33	106.26	106.29	4800.0
2015-02-13 08:00:00	QQQ	ETF	106.24	106.33	106.23	106.33	22985.0
2015-02-13 08:30:00	QQQ	ETF	106.3	106.36	106.27	106.35	18350.0
2015-02-13 09:00:00	QQQ	ETF	106.34	106.35	106.2	106.3	475454.0
2015-02-13 09:30:00	QQQ	ETF	106.3	106.5	106.26	106.38	4590455.0
2015-02-13 10:00:00	QQQ	ETF	106.36	106.43	106.12	106.29	2639900.0
2015-02-13 10:30:00	QQQ	ETF	106.29	106.33	106.101	106.29	1513001.0
2015-02-13 11:00:00	QQQ	ETF	106.2991	106.45	106.29	106.385	932953.0
2015-02-13 11:30:00	QQQ	ETF	106.38	106.59	106.321	106.55	915878.0
2015-02-13 12:00:00	QQQ	ETF	106.56	106.58	106.46	106.4701	776893.0
2015-02-13 12:30:00	QQQ	ETF	106.47	106.54	106.44	106.491	661368.0
2015-02-13 13:00:00	QQQ	ETF	106.48	106.601	106.42	106.43	755464.0
2015-02-13 13:30:00	QQQ	ETF	106.42	106.43	106.22	106.39	1156676.0

> showing 50 of 12,770 rows — these rows as CSV

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