PREVIEW / etf_30min / 2015-08-14

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-14.parquet
  size:    360 KB
  rows:    12,132

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-08-14 04:00:00	SPY	ETF	208.92	209.0	208.79	208.79	1475.0
2015-08-14 04:30:00	SPY	ETF	208.79	208.87	208.58	208.66	801.0
2015-08-14 05:00:00	SPY	ETF	208.55	208.57	208.21	208.35	110875.0
2015-08-14 05:30:00	SPY	ETF	208.35	208.48	208.16	208.23	114092.0
2015-08-14 06:00:00	SPY	ETF	208.21	208.32	208.12	208.12	19500.0
2015-08-14 06:30:00	SPY	ETF	208.1	208.34	208.09	208.17	95168.0
2015-08-14 07:00:00	SPY	ETF	208.23	208.25	208.03	208.13	209131.0
2015-08-14 07:30:00	SPY	ETF	208.14	208.24	208.03	208.17	324648.0
2015-08-14 08:00:00	SPY	ETF	208.19	208.27	208.04	208.16	203030.0
2015-08-14 08:30:00	SPY	ETF	208.12	208.39	208.1	208.35	343044.0
2015-08-14 09:00:00	SPY	ETF	208.35	208.55	208.28	208.45	265603.0
2015-08-14 09:30:00	SPY	ETF	208.43	209.07	208.33	208.97	7795019.0
2015-08-14 10:00:00	SPY	ETF	208.97	209.11	208.73	208.76	4714720.0
2015-08-14 10:30:00	SPY	ETF	208.761	208.98	208.56	208.66	4265360.0
2015-08-14 11:00:00	SPY	ETF	208.65	208.74	208.26	208.57	4523039.0
2015-08-14 11:30:00	SPY	ETF	208.58	208.94	208.47	208.86	2752142.0
2015-08-14 12:00:00	SPY	ETF	208.86	208.95	208.76	208.88	2456335.0
2015-08-14 12:30:00	SPY	ETF	208.88	209.02	208.6	208.81	3258283.0
2015-08-14 13:00:00	SPY	ETF	208.805	209.175	208.72	209.11	4013839.0
2015-08-14 13:30:00	SPY	ETF	209.12	209.23	208.87	209.01	2987575.0
2015-08-14 14:00:00	SPY	ETF	209.015	209.135	208.92	209.025	3834080.0
2015-08-14 14:30:00	SPY	ETF	209.02	209.21	208.94	209.115	3611209.0
2015-08-14 15:00:00	SPY	ETF	209.11	209.49	209.11	209.4499	6989745.0
2015-08-14 15:30:00	SPY	ETF	209.44	209.5087	209.31	209.4	12773016.0
2015-08-14 16:00:00	SPY	ETF	209.4	209.61	209.33	209.55	3291186.0
2015-08-14 16:30:00	SPY	ETF	209.55	209.7	209.42	209.65	2527578.0
2015-08-14 17:00:00	SPY	ETF	209.65	209.69	209.62	209.67	315404.0
2015-08-14 17:30:00	SPY	ETF	209.68	209.71	209.39	209.66	161159.0
2015-08-14 18:00:00	SPY	ETF	209.64	209.64	209.53	209.57	33015.0
2015-08-14 18:30:00	SPY	ETF	209.6	209.66	209.57	209.66	11429.0
2015-08-14 19:00:00	SPY	ETF	209.67	209.7	209.64	209.7	3091.0
2015-08-14 19:30:00	SPY	ETF	209.7	209.75	209.63	209.75	17306.0
2015-08-14 04:00:00	QQQ	ETF	110.36	110.4	110.33	110.4	12000.0
2015-08-14 04:30:00	QQQ	ETF	110.32	110.32	110.32	110.32	200.0
2015-08-14 05:30:00	QQQ	ETF	110.05	110.05	110.0	110.04	620.0
2015-08-14 06:00:00	QQQ	ETF	110.1	110.1	109.94	109.94	10600.0
2015-08-14 06:30:00	QQQ	ETF	110.03	110.03	110.03	110.03	100.0
2015-08-14 07:00:00	QQQ	ETF	110.03	110.03	109.96	109.99	18350.0
2015-08-14 07:30:00	QQQ	ETF	109.98	110.04	109.95	110.0	53434.0
2015-08-14 08:00:00	QQQ	ETF	110.0	110.06	109.93	109.94	85464.0
2015-08-14 08:30:00	QQQ	ETF	109.93	110.1	109.93	110.1	30497.0
2015-08-14 09:00:00	QQQ	ETF	110.12	110.16	110.04	110.09	55410.0
2015-08-14 09:30:00	QQQ	ETF	110.09	110.46	109.93	110.38	2926271.0
2015-08-14 10:00:00	QQQ	ETF	110.38	110.48	110.08	110.08	1409503.0
2015-08-14 10:30:00	QQQ	ETF	110.08	110.36	110.01	110.1	1235617.0
2015-08-14 11:00:00	QQQ	ETF	110.1	110.19	109.86	110.03	1251247.0
2015-08-14 11:30:00	QQQ	ETF	110.04	110.26	109.94	110.2	843701.0
2015-08-14 12:00:00	QQQ	ETF	110.2	110.28	110.094	110.195	392509.0
2015-08-14 12:30:00	QQQ	ETF	110.19	110.275	110.0	110.09	661484.0
2015-08-14 13:00:00	QQQ	ETF	110.09	110.4	110.04	110.37	739912.0

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

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