PREVIEW / etf_30min / 2015-03-24

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-24.parquet
  size:    374 KB
  rows:    12,541

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-24 04:00:00	SPY	ETF	209.92	209.98	209.92	209.98	325.0
2015-03-24 04:30:00	SPY	ETF	210.14	210.21	210.05	210.05	750.0
2015-03-24 05:00:00	SPY	ETF	210.04	210.28	209.94	210.28	3890.0
2015-03-24 05:30:00	SPY	ETF	210.17	210.17	210.17	210.17	1003.0
2015-03-24 06:00:00	SPY	ETF	210.28	210.49	210.28	210.44	17600.0
2015-03-24 06:30:00	SPY	ETF	210.36	210.37	210.17	210.23	42150.0
2015-03-24 07:00:00	SPY	ETF	210.27	210.36	210.15	210.34	65993.0
2015-03-24 07:30:00	SPY	ETF	210.32	210.46	210.24	210.4	86680.0
2015-03-24 08:00:00	SPY	ETF	210.38	210.42	210.16	210.29	170519.0
2015-03-24 08:30:00	SPY	ETF	210.28	210.34	210.04	210.19	605959.0
2015-03-24 09:00:00	SPY	ETF	210.18	210.18	209.68	209.87	830319.0
2015-03-24 09:30:00	SPY	ETF	209.85	210.01	209.45	209.98	7570852.0
2015-03-24 10:00:00	SPY	ETF	209.98	210.23	209.88	210.02	5532712.0
2015-03-24 10:30:00	SPY	ETF	210.03	210.12	209.84	210.0041	3145126.0
2015-03-24 11:00:00	SPY	ETF	210.01	210.4	209.86	210.29	4758758.0
2015-03-24 11:30:00	SPY	ETF	210.29	210.35	210.09	210.14	2717946.0
2015-03-24 12:00:00	SPY	ETF	210.14	210.27	209.9	209.915	3182408.0
2015-03-24 12:30:00	SPY	ETF	209.92	209.96	209.52	209.54	4816731.0
2015-03-24 13:00:00	SPY	ETF	209.54	209.74	209.23	209.3175	3944701.0
2015-03-24 13:30:00	SPY	ETF	209.31	209.595	209.22	209.51	3278682.0
2015-03-24 14:00:00	SPY	ETF	209.51	209.52	209.05	209.16	3965484.0
2015-03-24 14:30:00	SPY	ETF	209.155	209.33	208.98	209.22	3821639.0
2015-03-24 15:00:00	SPY	ETF	209.22	209.5	208.93	208.95	6642300.0
2015-03-24 15:30:00	SPY	ETF	208.95	209.9699	208.74	208.81	11796549.0
2015-03-24 16:00:00	SPY	ETF	208.8	210.1887	208.72	208.97	4332986.0
2015-03-24 16:30:00	SPY	ETF	208.97	208.98	208.82	208.92	1849077.0
2015-03-24 17:00:00	SPY	ETF	208.92	209.53	208.7574	208.9	1923727.0
2015-03-24 17:30:00	SPY	ETF	208.89	208.93	208.87	208.9	103710.0
2015-03-24 18:00:00	SPY	ETF	208.91	208.97	208.9	208.93	45655.0
2015-03-24 18:30:00	SPY	ETF	208.94	208.95	208.93	208.95	1385.0
2015-03-24 19:00:00	SPY	ETF	208.94	208.94	208.92	208.92	19896.0
2015-03-24 19:30:00	SPY	ETF	208.92	209.0	208.92	208.99	19312.0
2015-03-24 04:30:00	QQQ	ETF	108.32	108.32	108.32	108.32	1000.0
2015-03-24 07:00:00	QQQ	ETF	108.48	108.48	108.4	108.45	3000.0
2015-03-24 07:30:00	QQQ	ETF	108.43	108.54	108.43	108.52	32824.0
2015-03-24 08:00:00	QQQ	ETF	108.51	108.51	108.44	108.48	47217.0
2015-03-24 08:30:00	QQQ	ETF	108.47	108.47	108.36	108.41	47090.0
2015-03-24 09:00:00	QQQ	ETF	108.37	108.37	108.16	108.29	253263.0
2015-03-24 09:30:00	QQQ	ETF	108.31	108.43	108.11	108.43	2689732.0
2015-03-24 10:00:00	QQQ	ETF	108.43	108.65	108.42	108.55	1828517.0
2015-03-24 10:30:00	QQQ	ETF	108.56	108.7	108.5373	108.66	824091.0
2015-03-24 11:00:00	QQQ	ETF	108.66	108.81	108.58	108.75	793970.0
2015-03-24 11:30:00	QQQ	ETF	108.75	108.79	108.7	108.74	565478.0
2015-03-24 12:00:00	QQQ	ETF	108.73	108.775	108.56	108.56	509184.0
2015-03-24 12:30:00	QQQ	ETF	108.57	108.58	108.36	108.365	710197.0
2015-03-24 13:00:00	QQQ	ETF	108.36	108.49	108.18	108.2257	999579.0
2015-03-24 13:30:00	QQQ	ETF	108.22	108.36	108.15	108.33	604822.0
2015-03-24 14:00:00	QQQ	ETF	108.32	108.32	108.03	108.085	1058121.0
2015-03-24 14:30:00	QQQ	ETF	108.08	108.21	107.99	108.14	990565.0
2015-03-24 15:00:00	QQQ	ETF	108.14	108.2999	107.99	107.99	1275967.0

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

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