PREVIEW / etf_30min / 2013-06-17

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-06-17.parquet
  size:    315 KB
  rows:    10,775

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-06-17 04:00:00	SPY	ETF	163.82	164.5	163.73	164.31	34607.0
2013-06-17 04:30:00	SPY	ETF	164.28	164.34	164.22	164.34	2150.0
2013-06-17 05:00:00	SPY	ETF	164.35	164.48	164.35	164.43	2490.0
2013-06-17 05:30:00	SPY	ETF	164.48	164.56	164.46	164.54	38621.0
2013-06-17 06:00:00	SPY	ETF	164.53	164.6	164.45	164.45	53357.0
2013-06-17 06:30:00	SPY	ETF	164.48	164.52	164.38	164.44	74544.0
2013-06-17 07:00:00	SPY	ETF	164.41	164.465	164.31	164.35	102087.0
2013-06-17 07:30:00	SPY	ETF	164.35	164.4	164.13	164.19	350617.0
2013-06-17 08:00:00	SPY	ETF	164.19	164.45	164.08	164.3	954729.0
2013-06-17 08:30:00	SPY	ETF	164.32	164.36	164.11	164.27	841684.0
2013-06-17 09:00:00	SPY	ETF	164.27	164.36	164.15	164.29	863250.0
2013-06-17 09:30:00	SPY	ETF	164.29	164.96	164.29	164.81	14784932.0
2013-06-17 10:00:00	SPY	ETF	164.83	164.99	164.68	164.87	11210997.0
2013-06-17 10:30:00	SPY	ETF	164.88	165.06	164.74	165.03	6108959.0
2013-06-17 11:00:00	SPY	ETF	165.03	165.22	164.89	164.979	8337518.0
2013-06-17 11:30:00	SPY	ETF	164.99	165.02	164.75	164.87	6852832.0
2013-06-17 12:00:00	SPY	ETF	164.87	164.92	164.73	164.7599	3672778.0
2013-06-17 12:30:00	SPY	ETF	164.75	164.95	164.75	164.82	2372310.0
2013-06-17 13:00:00	SPY	ETF	164.82	165.04	164.72	164.97	4327931.0
2013-06-17 13:30:00	SPY	ETF	164.97	165.1	164.92	164.9799	3040242.0
2013-06-17 14:00:00	SPY	ETF	164.975	165.01	164.05	164.21	12515134.0
2013-06-17 14:30:00	SPY	ETF	164.21	164.38	163.55	163.765	12382025.0
2013-06-17 15:00:00	SPY	ETF	163.76	164.05	163.62	164.02	11203529.0
2013-06-17 15:30:00	SPY	ETF	164.02	164.65	163.99	164.45	21227674.0
2013-06-17 16:00:00	SPY	ETF	164.45	164.8366	164.3164	164.6	5835569.0
2013-06-17 16:30:00	SPY	ETF	164.59	164.66	164.59	164.63	3469745.0
2013-06-17 17:00:00	SPY	ETF	164.61	164.7	164.57	164.58	223546.0
2013-06-17 17:30:00	SPY	ETF	164.6	164.63	164.58	164.61	59649.0
2013-06-17 18:00:00	SPY	ETF	164.61	164.67	164.55	164.58	153407.0
2013-06-17 18:30:00	SPY	ETF	164.6	164.67	164.6	164.67	3620.0
2013-06-17 19:00:00	SPY	ETF	164.63	164.66	164.62	164.65	7340.0
2013-06-17 19:30:00	SPY	ETF	164.65	164.67	164.56	164.59	31217.0
2013-06-17 04:00:00	QQQ	ETF	72.8	72.98	72.26	72.92	29995.0
2013-06-17 04:30:00	QQQ	ETF	72.92	72.96	72.9	72.92	3126.0
2013-06-17 05:00:00	QQQ	ETF	72.94	72.99	72.94	72.99	4200.0
2013-06-17 06:00:00	QQQ	ETF	72.99	73.02	72.99	73.02	1800.0
2013-06-17 06:30:00	QQQ	ETF	73.0	73.0	72.96	72.98	3100.0
2013-06-17 07:00:00	QQQ	ETF	72.96	72.96	72.91	72.91	13116.0
2013-06-17 07:30:00	QQQ	ETF	72.94	72.95	72.85	72.86	11448.0
2013-06-17 08:00:00	QQQ	ETF	72.87	72.91	72.81	72.87	51955.0
2013-06-17 08:30:00	QQQ	ETF	72.9	72.92	72.81	72.9	40971.0
2013-06-17 09:00:00	QQQ	ETF	72.87	72.9	72.84	72.86	69452.0
2013-06-17 09:30:00	QQQ	ETF	72.88	73.12	72.85	73.08	4381828.0
2013-06-17 10:00:00	QQQ	ETF	73.08	73.27	73.03	73.23	3503990.0
2013-06-17 10:30:00	QQQ	ETF	73.25	73.29	73.142	73.26	1203179.0
2013-06-17 11:00:00	QQQ	ETF	73.27	73.4	73.24	73.34	1688766.0
2013-06-17 11:30:00	QQQ	ETF	73.34	73.36	73.2	73.26	1484903.0
2013-06-17 12:00:00	QQQ	ETF	73.26	73.2901	73.22	73.2788	722549.0
2013-06-17 12:30:00	QQQ	ETF	73.28	73.33	73.24	73.3	633333.0
2013-06-17 13:00:00	QQQ	ETF	73.3	73.38	73.2301	73.34	931775.0

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

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