PREVIEW / etf_30min / 2015-04-20

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-20.parquet
  size:    379 KB
  rows:    12,893

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-04-20 04:00:00	SPY	ETF	209.17	209.39	209.17	209.21	10161.0
2015-04-20 04:30:00	SPY	ETF	209.25	209.3	209.19	209.19	19395.0
2015-04-20 05:00:00	SPY	ETF	209.16	209.3	209.1	209.3	27400.0
2015-04-20 05:30:00	SPY	ETF	209.25	209.25	209.14	209.19	76019.0
2015-04-20 06:00:00	SPY	ETF	209.17	209.22	209.14	209.19	58758.0
2015-04-20 06:30:00	SPY	ETF	209.2	209.45	209.2	209.35	154667.0
2015-04-20 07:00:00	SPY	ETF	209.36	209.36	209.16	209.2	130542.0
2015-04-20 07:30:00	SPY	ETF	209.16	209.18	208.71	209.0	276842.0
2015-04-20 08:00:00	SPY	ETF	208.51	209.3	208.51	209.1	458913.0
2015-04-20 08:30:00	SPY	ETF	209.11	209.31	207.98	209.24	201657.0
2015-04-20 09:00:00	SPY	ETF	209.24	209.28	209.04	209.07	435968.0
2015-04-20 09:30:00	SPY	ETF	209.06	209.91	208.96	209.8	14220597.0
2015-04-20 10:00:00	SPY	ETF	209.8	209.95	209.53	209.73	9503173.0
2015-04-20 10:30:00	SPY	ETF	209.74	210.09	209.72	210.05	5041845.0
2015-04-20 11:00:00	SPY	ETF	210.05	210.25	209.97	210.02	6556881.0
2015-04-20 11:30:00	SPY	ETF	210.03	210.17	210.01	210.16	3290227.0
2015-04-20 12:00:00	SPY	ETF	210.15	210.17	210.04	210.09	1866810.0
2015-04-20 12:30:00	SPY	ETF	210.0915	210.135	209.95	210.03	2289469.0
2015-04-20 13:00:00	SPY	ETF	210.03	210.18	209.85	209.94	3011662.0
2015-04-20 13:30:00	SPY	ETF	209.95	210.01	209.85	209.86	3788653.0
2015-04-20 14:00:00	SPY	ETF	209.875	209.94	209.71	209.86	3042321.0
2015-04-20 14:30:00	SPY	ETF	209.86	209.97	209.765	209.96	2813312.0
2015-04-20 15:00:00	SPY	ETF	209.96	210.2	209.9	210.01	6196920.0
2015-04-20 15:30:00	SPY	ETF	210.01	210.12	209.77	209.85	11051793.0
2015-04-20 16:00:00	SPY	ETF	209.84	209.9	209.11	209.63	9019171.0
2015-04-20 16:30:00	SPY	ETF	209.62	209.8732	209.53	209.58	2691879.0
2015-04-20 17:00:00	SPY	ETF	209.58	209.58	209.46	209.5	902038.0
2015-04-20 17:30:00	SPY	ETF	209.48	209.51	209.47	209.5	46428.0
2015-04-20 18:00:00	SPY	ETF	209.5	209.68	209.5	209.68	64220.0
2015-04-20 18:30:00	SPY	ETF	209.66	209.66	209.61	209.65	11687.0
2015-04-20 19:00:00	SPY	ETF	209.65	209.67	209.631	209.65	6350.0
2015-04-20 19:30:00	SPY	ETF	209.67	209.77	209.65	209.77	17315.0
2015-04-20 04:00:00	QQQ	ETF	106.53	106.65	106.53	106.65	776.0
2015-04-20 04:30:00	QQQ	ETF	106.62	106.62	106.62	106.62	392.0
2015-04-20 06:00:00	QQQ	ETF	106.61	106.61	106.59	106.59	14600.0
2015-04-20 06:30:00	QQQ	ETF	106.62	106.7	106.62	106.66	8109.0
2015-04-20 07:00:00	QQQ	ETF	106.64	106.69	106.59	106.59	21501.0
2015-04-20 07:30:00	QQQ	ETF	106.59	106.59	106.44	106.47	51368.0
2015-04-20 08:00:00	QQQ	ETF	106.47	106.54	106.44	106.52	128401.0
2015-04-20 08:30:00	QQQ	ETF	106.54	106.62	106.01	106.58	109723.0
2015-04-20 09:00:00	QQQ	ETF	106.59	106.6	106.52	106.53	110134.0
2015-04-20 09:30:00	QQQ	ETF	106.54	107.14	106.5	107.14	5022132.0
2015-04-20 10:00:00	QQQ	ETF	107.14	107.29	107.0	107.11	2027286.0
2015-04-20 10:30:00	QQQ	ETF	107.11	107.425	107.11	107.38	1387979.0
2015-04-20 11:00:00	QQQ	ETF	107.39	107.55	107.38	107.47	2282880.0
2015-04-20 11:30:00	QQQ	ETF	107.47	107.56	107.4	107.55	1300760.0
2015-04-20 12:00:00	QQQ	ETF	107.55	107.56	107.46	107.49	850011.0
2015-04-20 12:30:00	QQQ	ETF	107.49	107.52	107.4101	107.48	558371.0
2015-04-20 13:00:00	QQQ	ETF	107.48	107.62	107.43	107.5	943659.0
2015-04-20 13:30:00	QQQ	ETF	107.5	107.58	107.4737	107.57	521109.0

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

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