PREVIEW / etf_30min / 2015-03-19

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-19.parquet
  size:    372 KB
  rows:    12,513

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-03-19 04:00:00	SPY	ETF	210.71	210.92	210.37	210.37	4625.0
2015-03-19 04:30:00	SPY	ETF	210.44	210.46	210.05	210.05	133361.0
2015-03-19 05:00:00	SPY	ETF	210.01	210.12	209.96	210.0	2621.0
2015-03-19 05:30:00	SPY	ETF	210.2	210.24	209.85	210.2	6230.0
2015-03-19 06:00:00	SPY	ETF	210.16	210.42	210.16	210.41	23062.0
2015-03-19 06:30:00	SPY	ETF	210.42	210.49	210.21	210.45	83111.0
2015-03-19 07:00:00	SPY	ETF	210.46	210.46	210.2	210.44	165431.0
2015-03-19 07:30:00	SPY	ETF	210.41	210.46	210.23	210.28	103056.0
2015-03-19 08:00:00	SPY	ETF	210.28	210.41	210.0	210.06	495779.0
2015-03-19 08:30:00	SPY	ETF	210.09	210.09	209.74	209.93	868746.0
2015-03-19 09:00:00	SPY	ETF	209.92	209.99	209.82	209.95	495519.0
2015-03-19 09:30:00	SPY	ETF	209.96	210.1	209.49	210.02	11745711.0
2015-03-19 10:00:00	SPY	ETF	209.99	210.29	209.81	210.05	8255490.0
2015-03-19 10:30:00	SPY	ETF	210.04	210.4697	209.475	209.711	7639627.0
2015-03-19 11:00:00	SPY	ETF	209.71	209.87	209.5	209.66	4592167.0
2015-03-19 11:30:00	SPY	ETF	209.66	209.69	209.03	209.32	8751025.0
2015-03-19 12:00:00	SPY	ETF	209.345	209.46	209.21	209.425	4838702.0
2015-03-19 12:30:00	SPY	ETF	209.43	209.45	209.07	209.1728	9689002.0
2015-03-19 13:00:00	SPY	ETF	209.17	209.76	209.07	209.7	4952879.0
2015-03-19 13:30:00	SPY	ETF	209.7	209.72	209.3105	209.36	3822972.0
2015-03-19 14:00:00	SPY	ETF	209.35	209.81	209.32	209.5013	6027480.0
2015-03-19 14:30:00	SPY	ETF	209.505	209.74	209.36	209.68	5764864.0
2015-03-19 15:00:00	SPY	ETF	209.69	209.85	209.31	209.57	9648017.0
2015-03-19 15:30:00	SPY	ETF	209.56	209.77	209.4	209.48	14809864.0
2015-03-19 16:00:00	SPY	ETF	209.48	209.65	209.3319	209.55	4849318.0
2015-03-19 16:30:00	SPY	ETF	209.55	209.56	209.43	209.44	1416624.0
2015-03-19 17:00:00	SPY	ETF	209.43	209.5	209.28	209.3	4397755.0
2015-03-19 17:30:00	SPY	ETF	209.28	209.5	209.28	209.34	88460.0
2015-03-19 18:00:00	SPY	ETF	209.31	209.31	209.2	209.24	39952.0
2015-03-19 18:30:00	SPY	ETF	209.24	209.25	209.18	209.18	43272.0
2015-03-19 19:00:00	SPY	ETF	209.18	209.28	209.18	209.27	27203.0
2015-03-19 19:30:00	SPY	ETF	209.27	209.45	209.26	209.43	31024.0
2015-03-19 04:00:00	QQQ	ETF	108.1	108.4	108.1	108.25	7138.0
2015-03-19 04:30:00	QQQ	ETF	108.0	108.0	108.0	108.0	140.0
2015-03-19 06:30:00	QQQ	ETF	108.06	108.12	108.06	108.11	7600.0
2015-03-19 07:00:00	QQQ	ETF	108.08	108.13	108.05	108.1	132316.0
2015-03-19 07:30:00	QQQ	ETF	108.09	108.11	108.04	108.08	91338.0
2015-03-19 08:00:00	QQQ	ETF	108.07	108.1	107.97	108.0	286203.0
2015-03-19 08:30:00	QQQ	ETF	108.0	108.0	107.9	107.985	68802.0
2015-03-19 09:00:00	QQQ	ETF	107.98	108.04	107.94	108.04	82149.0
2015-03-19 09:30:00	QQQ	ETF	108.03	108.25	107.9	108.2	2995704.0
2015-03-19 10:00:00	QQQ	ETF	108.2	108.38	108.11	108.26	2427412.0
2015-03-19 10:30:00	QQQ	ETF	108.26	108.26	108.03	108.1999	2322772.0
2015-03-19 11:00:00	QQQ	ETF	108.19	108.28	108.06	108.21	1448348.0
2015-03-19 11:30:00	QQQ	ETF	108.22	108.235	108.0	108.17	1896711.0
2015-03-19 12:00:00	QQQ	ETF	108.17	108.22	108.05	108.16	1176652.0
2015-03-19 12:30:00	QQQ	ETF	108.16	108.1692	107.925	107.94	1114196.0
2015-03-19 13:00:00	QQQ	ETF	107.93	108.29	107.87	108.24	1136281.0
2015-03-19 13:30:00	QQQ	ETF	108.24	108.275	108.04	108.07	1145803.0
2015-03-19 14:00:00	QQQ	ETF	108.08	108.285	108.05	108.18	1103711.0

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

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