PREVIEW / etf_30min / 2015-04-30

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-30.parquet
  size:    393 KB
  rows:    13,197

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-30 04:00:00	SPY	ETF	210.05	210.05	209.58	209.78	25779.0
2015-04-30 04:30:00	SPY	ETF	209.95	210.14	209.93	210.01	7320.0
2015-04-30 05:00:00	SPY	ETF	209.88	210.0	209.66	209.66	16883.0
2015-04-30 05:30:00	SPY	ETF	209.68	209.93	209.64	209.87	28502.0
2015-04-30 06:00:00	SPY	ETF	209.76	209.99	209.76	209.84	16150.0
2015-04-30 06:30:00	SPY	ETF	209.96	210.02	209.86	209.98	20151.0
2015-04-30 07:00:00	SPY	ETF	209.99	210.09	209.82	209.82	175808.0
2015-04-30 07:30:00	SPY	ETF	209.84	210.07	209.82	210.02	90244.0
2015-04-30 08:00:00	SPY	ETF	210.01	210.22	209.89	210.15	609083.0
2015-04-30 08:30:00	SPY	ETF	210.24	210.42	209.97	210.14	926969.0
2015-04-30 09:00:00	SPY	ETF	210.14	210.16	209.62	209.87	733136.0
2015-04-30 09:30:00	SPY	ETF	209.88	210.35	209.28	209.3	14948846.0
2015-04-30 10:00:00	SPY	ETF	209.29	209.52	208.92	209.07	14161245.0
2015-04-30 10:30:00	SPY	ETF	209.07	209.43	208.99	209.26	7677746.0
2015-04-30 11:00:00	SPY	ETF	209.25	210.06	209.25	209.94	8785361.0
2015-04-30 11:30:00	SPY	ETF	209.95	210.2	209.44	209.45	6522495.0
2015-04-30 12:00:00	SPY	ETF	209.44	209.72	209.38	209.52	4023388.0
2015-04-30 12:30:00	SPY	ETF	209.5199	209.52	208.97	209.31	7185742.0
2015-04-30 13:00:00	SPY	ETF	209.315	209.54	209.19	209.33	3211850.0
2015-04-30 13:30:00	SPY	ETF	209.33	209.54	209.2	209.245	3863350.0
2015-04-30 14:00:00	SPY	ETF	209.245	209.43	208.75	208.77	9331793.0
2015-04-30 14:30:00	SPY	ETF	208.765	208.9	208.15	208.195	11359585.0
2015-04-30 15:00:00	SPY	ETF	208.19	208.33	207.62	207.98	20248958.0
2015-04-30 15:30:00	SPY	ETF	207.98	209.6508	207.82	208.46	23949376.0
2015-04-30 16:00:00	SPY	ETF	208.46	210.5869	208.1775	208.75	9103733.0
2015-04-30 16:30:00	SPY	ETF	208.76	210.5869	208.52	208.82	8343500.0
2015-04-30 17:00:00	SPY	ETF	208.82	208.94	208.81	208.82	419372.0
2015-04-30 17:30:00	SPY	ETF	208.82	208.9	208.81	208.83	210373.0
2015-04-30 18:00:00	SPY	ETF	208.83	208.9	208.46	208.75	361935.0
2015-04-30 18:30:00	SPY	ETF	208.78	208.78	208.73	208.76	10202.0
2015-04-30 19:00:00	SPY	ETF	208.78	208.78	208.67	208.71	25502.0
2015-04-30 19:30:00	SPY	ETF	208.68	208.76	208.65	208.71	45303.0
2015-04-30 04:00:00	QQQ	ETF	108.93	108.93	108.65	108.78	10900.0
2015-04-30 05:30:00	QQQ	ETF	108.66	108.66	108.66	108.66	6200.0
2015-04-30 06:00:00	QQQ	ETF	108.73	108.77	108.73	108.77	12500.0
2015-04-30 06:30:00	QQQ	ETF	108.8	108.8	108.8	108.8	1000.0
2015-04-30 07:00:00	QQQ	ETF	108.91	108.91	108.77	108.77	3121.0
2015-04-30 07:30:00	QQQ	ETF	108.76	108.83	108.7	108.79	41850.0
2015-04-30 08:00:00	QQQ	ETF	108.8	108.91	108.72	108.89	185331.0
2015-04-30 08:30:00	QQQ	ETF	108.91	109.03	108.81	108.93	158088.0
2015-04-30 09:00:00	QQQ	ETF	108.94	108.94	108.63	108.74	261763.0
2015-04-30 09:30:00	QQQ	ETF	108.73	109.17	108.53	108.534	5417067.0
2015-04-30 10:00:00	QQQ	ETF	108.53	108.7	108.21	108.31	3204557.0
2015-04-30 10:30:00	QQQ	ETF	108.3	108.45	108.13	108.26	1947343.0
2015-04-30 11:00:00	QQQ	ETF	108.26	108.77	108.25	108.66	2279616.0
2015-04-30 11:30:00	QQQ	ETF	108.67	108.805	108.28	108.29	1319452.0
2015-04-30 12:00:00	QQQ	ETF	108.3	108.48	108.25	108.33	989518.0
2015-04-30 12:30:00	QQQ	ETF	108.32	108.3201	107.93	108.12	1797924.0
2015-04-30 13:00:00	QQQ	ETF	108.121	108.24	108.02	108.08	1136241.0
2015-04-30 13:30:00	QQQ	ETF	108.08	108.19	107.95	107.95	2010282.0

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

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