PREVIEW / etf_30min / 2014-05-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-06.parquet
  size:    326 KB
  rows:    11,225

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
2014-05-06 04:00:00	SPY	ETF	188.5	188.62	188.25	188.25	1352.0
2014-05-06 04:30:00	SPY	ETF	188.34	188.35	188.32	188.32	442.0
2014-05-06 05:00:00	SPY	ETF	188.53	188.53	188.53	188.53	424.0
2014-05-06 06:00:00	SPY	ETF	188.42	188.42	188.39	188.41	2348.0
2014-05-06 06:30:00	SPY	ETF	188.38	188.38	188.26	188.26	2917.0
2014-05-06 07:00:00	SPY	ETF	188.27	188.27	188.1	188.2	22863.0
2014-05-06 07:30:00	SPY	ETF	188.21	188.22	188.11	188.22	22238.0
2014-05-06 08:00:00	SPY	ETF	188.2	188.21	187.99	187.99	177564.0
2014-05-06 08:30:00	SPY	ETF	188.02	188.04	187.81	187.84	378373.0
2014-05-06 09:00:00	SPY	ETF	187.85	188.02	187.83	188.0	517002.0
2014-05-06 09:30:00	SPY	ETF	188.0	188.03	187.51	187.87	12545554.0
2014-05-06 10:00:00	SPY	ETF	187.87	187.97	187.54	187.94	7154638.0
2014-05-06 10:30:00	SPY	ETF	187.935	188.13	187.55	187.59	4872901.0
2014-05-06 11:00:00	SPY	ETF	187.56	187.8	187.43	187.65	3797624.0
2014-05-06 11:30:00	SPY	ETF	187.65	187.87	187.614	187.84	2513436.0
2014-05-06 12:00:00	SPY	ETF	187.83	187.87	187.5	187.61	2413215.0
2014-05-06 12:30:00	SPY	ETF	187.61	187.78	187.59	187.6651	1426150.0
2014-05-06 13:00:00	SPY	ETF	187.66	187.7	187.33	187.3599	3653460.0
2014-05-06 13:30:00	SPY	ETF	187.36	187.44	187.0	187.03	6282622.0
2014-05-06 14:00:00	SPY	ETF	187.04	187.18	186.82	186.965	6013824.0
2014-05-06 14:30:00	SPY	ETF	186.965	187.15	186.86	186.96	3253289.0
2014-05-06 15:00:00	SPY	ETF	186.965	187.25	186.77	187.0536	5026427.0
2014-05-06 15:30:00	SPY	ETF	187.055	187.18	186.74	186.82	12374784.0
2014-05-06 16:00:00	SPY	ETF	186.82	188.4499	186.78	186.97	6756885.0
2014-05-06 16:30:00	SPY	ETF	186.98	187.05	186.7601	187.0	4211450.0
2014-05-06 17:00:00	SPY	ETF	187.0	187.03	186.92	186.95	534826.0
2014-05-06 17:30:00	SPY	ETF	186.95	186.95	186.9	186.93	56690.0
2014-05-06 18:00:00	SPY	ETF	186.93	187.02	186.93	186.97	52125.0
2014-05-06 18:30:00	SPY	ETF	186.97	186.97	186.88	186.92	11106.0
2014-05-06 19:00:00	SPY	ETF	186.9	186.9	186.86	186.88	10711.0
2014-05-06 19:30:00	SPY	ETF	186.89	186.96	186.86	186.91	16345.0
2014-05-06 04:00:00	QQQ	ETF	88.03	88.03	87.85	87.85	1100.0
2014-05-06 05:00:00	QQQ	ETF	88.0	88.1	88.0	88.1	6850.0
2014-05-06 06:30:00	QQQ	ETF	88.02	88.02	87.96	87.96	2200.0
2014-05-06 07:00:00	QQQ	ETF	88.0	88.0	87.8	87.8	1500.0
2014-05-06 08:00:00	QQQ	ETF	87.95	87.95	87.72	87.76	67813.0
2014-05-06 08:30:00	QQQ	ETF	87.76	87.77	87.63	87.69	126255.0
2014-05-06 09:00:00	QQQ	ETF	87.67	87.84	87.67	87.82	98287.0
2014-05-06 09:30:00	QQQ	ETF	87.83	87.84	87.51	87.81	4786917.0
2014-05-06 10:00:00	QQQ	ETF	87.82	87.83	87.54	87.76	2389273.0
2014-05-06 10:30:00	QQQ	ETF	87.77	87.86	87.43	87.46	2112075.0
2014-05-06 11:00:00	QQQ	ETF	87.45	87.54	87.36	87.46	1970450.0
2014-05-06 11:30:00	QQQ	ETF	87.46	87.6	87.43	87.59	686429.0
2014-05-06 12:00:00	QQQ	ETF	87.59	87.6	87.43	87.48	694716.0
2014-05-06 12:30:00	QQQ	ETF	87.48	87.57	87.48	87.527	522315.0
2014-05-06 13:00:00	QQQ	ETF	87.53	87.54	87.28	87.3	1339213.0
2014-05-06 13:30:00	QQQ	ETF	87.2926	87.36	87.02	87.0399	2374454.0
2014-05-06 14:00:00	QQQ	ETF	87.03	87.1	86.89	86.9996	1967825.0
2014-05-06 14:30:00	QQQ	ETF	86.99	87.07	86.93	86.955	1082643.0
2014-05-06 15:00:00	QQQ	ETF	86.95	87.13	86.86	87.04	1883199.0

> showing 50 of 11,225 rows — these rows as CSV

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