PREVIEW / etf_30min / 2013-12-24

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-24.parquet
  size:    199 KB
  rows:    6,409

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
2013-12-24 04:00:00	SPY	ETF	182.62	182.62	182.58	182.62	2850.0
2013-12-24 04:30:00	SPY	ETF	182.58	182.61	182.57	182.61	2500.0
2013-12-24 05:00:00	SPY	ETF	182.58	182.63	182.58	182.63	8301.0
2013-12-24 05:30:00	SPY	ETF	182.63	182.63	182.56	182.59	3801.0
2013-12-24 06:00:00	SPY	ETF	182.58	182.64	182.57	182.58	4800.0
2013-12-24 06:30:00	SPY	ETF	182.58	182.58	182.51	182.51	3514.0
2013-12-24 07:00:00	SPY	ETF	182.5	182.5	182.4	182.4	19651.0
2013-12-24 07:30:00	SPY	ETF	182.39	182.48	182.39	182.46	21432.0
2013-12-24 08:00:00	SPY	ETF	182.44	182.52	182.43	182.52	26574.0
2013-12-24 08:30:00	SPY	ETF	182.51	182.59	182.51	182.57	175025.0
2013-12-24 09:00:00	SPY	ETF	182.56	182.61	182.49	182.54	296432.0
2013-12-24 09:30:00	SPY	ETF	182.54	182.71	182.53	182.64	10241537.0
2013-12-24 10:00:00	SPY	ETF	182.645	182.85	182.62	182.8299	4928794.0
2013-12-24 10:30:00	SPY	ETF	182.82	182.89	182.74	182.86	3565656.0
2013-12-24 11:00:00	SPY	ETF	182.86	182.96	182.81	182.91	4081121.0
2013-12-24 11:30:00	SPY	ETF	182.9099	182.99	182.88	182.94	3444283.0
2013-12-24 12:00:00	SPY	ETF	182.955	182.99	182.9	182.931	4030289.0
2013-12-24 12:30:00	SPY	ETF	182.93	183.01	182.88	182.96	7871996.0
2013-12-24 13:00:00	SPY	ETF	182.96	183.37	182.4518	183.25	3087055.0
2013-12-24 13:30:00	SPY	ETF	183.24	183.45	183.2	183.35	361539.0
2013-12-24 14:00:00	SPY	ETF	183.35	183.43	183.29	183.43	205195.0
2013-12-24 14:30:00	SPY	ETF	183.4	183.4	182.93	182.93	1588133.0
2013-12-24 15:00:00	SPY	ETF	183.35	183.35	183.33	183.33	8400.0
2013-12-24 15:30:00	SPY	ETF	183.34	183.34	183.3	183.319	10418.0
2013-12-24 16:00:00	SPY	ETF	183.31	183.34	183.3	183.34	6716.0
2013-12-24 16:30:00	SPY	ETF	183.34	183.35	183.31	183.35	10541.0
2013-12-24 04:00:00	QQQ	ETF	87.39	87.39	87.39	87.39	100.0
2013-12-24 04:30:00	QQQ	ETF	87.39	87.39	87.39	87.39	240.0
2013-12-24 06:00:00	QQQ	ETF	87.38	87.38	87.38	87.38	100.0
2013-12-24 06:30:00	QQQ	ETF	87.36	87.36	87.36	87.36	800.0
2013-12-24 07:00:00	QQQ	ETF	87.34	87.35	87.32	87.35	10767.0
2013-12-24 07:30:00	QQQ	ETF	87.36	87.36	87.36	87.36	300.0
2013-12-24 08:00:00	QQQ	ETF	87.38	87.4	87.37	87.39	18300.0
2013-12-24 08:30:00	QQQ	ETF	87.4	87.42	87.38	87.4	21400.0
2013-12-24 09:00:00	QQQ	ETF	87.41	87.45	87.4	87.41	215643.0
2013-12-24 09:30:00	QQQ	ETF	87.42	87.51	87.3301	87.43	2831619.0
2013-12-24 10:00:00	QQQ	ETF	87.42	87.445	87.32	87.38	2445650.0
2013-12-24 10:30:00	QQQ	ETF	87.37	87.38	87.27	87.3405	1615152.0
2013-12-24 11:00:00	QQQ	ETF	87.345	87.415	87.33	87.355	756791.0
2013-12-24 11:30:00	QQQ	ETF	87.3508	87.42	87.35	87.37	801722.0
2013-12-24 12:00:00	QQQ	ETF	87.37	87.42	87.37	87.405	1270418.0
2013-12-24 12:30:00	QQQ	ETF	87.41	87.49	87.39	87.47	2239840.0
2013-12-24 13:00:00	QQQ	ETF	87.45	87.56	87.45	87.52	614329.0
2013-12-24 13:30:00	QQQ	ETF	87.58	87.59	87.52	87.5701	10085.0
2013-12-24 14:00:00	QQQ	ETF	87.57	87.58	87.57	87.58	7470.0
2013-12-24 14:30:00	QQQ	ETF	87.45	87.58	87.45	87.57	690284.0
2013-12-24 15:00:00	QQQ	ETF	87.57	87.57	87.57	87.57	200.0
2013-12-24 15:30:00	QQQ	ETF	87.6	87.6	87.6	87.6	100.0
2013-12-24 16:30:00	QQQ	ETF	87.57	87.59	87.57	87.59	1403.0
2013-12-24 07:30:00	IWM	ETF	114.66	114.66	114.66	114.66	5400.0

> showing 50 of 6,409 rows — these rows as CSV

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