PREVIEW / etf_30min / 2013-10-07

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-07.parquet
  size:    315 KB
  rows:    10,693

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-10-07 04:00:00	SPY	ETF	167.41	167.41	167.19	167.23	60990.0
2013-10-07 04:30:00	SPY	ETF	167.23	167.3	167.16	167.3	105058.0
2013-10-07 05:00:00	SPY	ETF	167.32	167.35	167.2	167.26	18900.0
2013-10-07 05:30:00	SPY	ETF	167.26	167.45	167.26	167.45	6498.0
2013-10-07 06:00:00	SPY	ETF	167.45	167.45	167.32	167.35	7566.0
2013-10-07 06:30:00	SPY	ETF	167.32	167.42	167.32	167.39	117655.0
2013-10-07 07:00:00	SPY	ETF	167.42	167.46	167.34	167.36	206503.0
2013-10-07 07:30:00	SPY	ETF	167.36	167.62	167.36	167.57	264373.0
2013-10-07 08:00:00	SPY	ETF	167.56	168.08	167.35	167.53	570798.0
2013-10-07 08:30:00	SPY	ETF	167.5	167.7	167.5	167.57	508985.0
2013-10-07 09:00:00	SPY	ETF	167.57	167.64	167.4	167.41	760103.0
2013-10-07 09:30:00	SPY	ETF	167.42	167.88	167.25	167.71	13654102.0
2013-10-07 10:00:00	SPY	ETF	167.72	168.35	167.61	168.23	10463701.0
2013-10-07 10:30:00	SPY	ETF	168.23	168.38	168.1	168.19	4656361.0
2013-10-07 11:00:00	SPY	ETF	168.19	168.22	167.93	168.011	5480788.0
2013-10-07 11:30:00	SPY	ETF	168.01	168.38	167.99	168.22	3386853.0
2013-10-07 12:00:00	SPY	ETF	168.21	168.24	167.96	167.99	2372858.0
2013-10-07 12:30:00	SPY	ETF	167.99	168.05	167.8	167.84	3365356.0
2013-10-07 13:00:00	SPY	ETF	167.83	168.17	167.825	168.04	4793551.0
2013-10-07 13:30:00	SPY	ETF	168.04	168.31	167.93	168.3	2993709.0
2013-10-07 14:00:00	SPY	ETF	168.3	168.45	168.06	168.21	4729738.0
2013-10-07 14:30:00	SPY	ETF	168.22	168.31	168.05	168.24	3449338.0
2013-10-07 15:00:00	SPY	ETF	168.24	168.29	167.91	167.95	4863352.0
2013-10-07 15:30:00	SPY	ETF	167.94	167.98	167.41	167.45	17855205.0
2013-10-07 16:00:00	SPY	ETF	167.44	168.14	167.22	167.3	5613949.0
2013-10-07 16:30:00	SPY	ETF	167.3	168.8986	167.27	167.29	1341411.0
2013-10-07 17:00:00	SPY	ETF	167.31	167.8027	167.18	167.2	1400622.0
2013-10-07 17:30:00	SPY	ETF	167.2	167.22	167.19	167.22	43776.0
2013-10-07 18:00:00	SPY	ETF	167.24	167.35	167.01	167.23	135750.0
2013-10-07 18:30:00	SPY	ETF	167.2	167.33	167.19	167.27	57076.0
2013-10-07 19:00:00	SPY	ETF	167.28	167.3	167.24	167.27	13550.0
2013-10-07 19:30:00	SPY	ETF	167.27	167.3	167.26	167.3	18423.0
2013-10-07 04:00:00	QQQ	ETF	78.92	78.92	78.61	78.64	42187.0
2013-10-07 04:30:00	QQQ	ETF	78.63	78.67	78.61	78.67	27200.0
2013-10-07 05:00:00	QQQ	ETF	78.68	78.68	78.64	78.66	6050.0
2013-10-07 05:30:00	QQQ	ETF	78.67	78.77	78.67	78.77	7850.0
2013-10-07 06:00:00	QQQ	ETF	78.78	78.78	78.68	78.7	40200.0
2013-10-07 06:30:00	QQQ	ETF	78.71	78.75	78.71	78.75	4800.0
2013-10-07 07:00:00	QQQ	ETF	78.76	78.76	78.72	78.73	22350.0
2013-10-07 07:30:00	QQQ	ETF	78.74	78.85	78.74	78.82	24300.0
2013-10-07 08:00:00	QQQ	ETF	78.82	78.84	78.76	78.82	93186.0
2013-10-07 08:30:00	QQQ	ETF	78.81	78.9	78.81	78.85	64201.0
2013-10-07 09:00:00	QQQ	ETF	78.84	78.86	78.71	78.71	128727.0
2013-10-07 09:30:00	QQQ	ETF	78.72	79.17	78.67	79.02	3681314.0
2013-10-07 10:00:00	QQQ	ETF	79.03	79.349	78.96	79.26	1967923.0
2013-10-07 10:30:00	QQQ	ETF	79.255	79.35	79.14	79.17	1148376.0
2013-10-07 11:00:00	QQQ	ETF	79.17	79.18	78.96	79.0	1017801.0
2013-10-07 11:30:00	QQQ	ETF	79.0	79.2	78.99	79.1	870610.0
2013-10-07 12:00:00	QQQ	ETF	79.09	79.14	78.93	78.9399	745667.0
2013-10-07 12:30:00	QQQ	ETF	78.93	79.02	78.83	78.85	689745.0

> showing 50 of 10,693 rows — these rows as CSV

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