PREVIEW / etf_30min / 2012-07-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-13.parquet
  size:    273 KB
  rows:    9,161

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
2012-07-13 04:00:00	SPY	ETF	133.8	133.85	133.72	133.74	3900.0
2012-07-13 04:30:00	SPY	ETF	133.7	133.85	133.7	133.85	543.0
2012-07-13 05:00:00	SPY	ETF	133.95	134.06	133.95	133.99	4900.0
2012-07-13 05:30:00	SPY	ETF	133.93	134.05	133.93	134.05	5500.0
2012-07-13 06:00:00	SPY	ETF	134.02	134.04	134.02	134.02	550.0
2012-07-13 06:30:00	SPY	ETF	134.07	134.28	134.07	134.1	291522.0
2012-07-13 07:00:00	SPY	ETF	134.1	134.11	133.82	133.89	172525.0
2012-07-13 07:30:00	SPY	ETF	133.92	134.05	133.83	133.86	543311.0
2012-07-13 08:00:00	SPY	ETF	133.88	134.04	133.76	133.92	1214450.0
2012-07-13 08:30:00	SPY	ETF	133.87	133.99	133.78	133.84	522600.0
2012-07-13 09:00:00	SPY	ETF	133.84	133.87	133.64	133.87	592522.0
2012-07-13 09:30:00	SPY	ETF	133.86	134.87	133.84	134.83	21325908.0
2012-07-13 10:00:00	SPY	ETF	134.83	135.36	134.76	135.02	15218726.0
2012-07-13 10:30:00	SPY	ETF	135.03	135.26	135.01	135.17	7711405.0
2012-07-13 11:00:00	SPY	ETF	135.17	135.23	135.03	135.15	6489515.0
2012-07-13 11:30:00	SPY	ETF	135.16	135.46	135.137	135.408	5226029.0
2012-07-13 12:00:00	SPY	ETF	135.4	135.54	135.33	135.391	4248973.0
2012-07-13 12:30:00	SPY	ETF	135.3927	135.46	135.38	135.44	2582415.0
2012-07-13 13:00:00	SPY	ETF	135.43	135.51	135.38	135.39	3959788.0
2012-07-13 13:30:00	SPY	ETF	135.39	135.54	135.34	135.45	3278389.0
2012-07-13 14:00:00	SPY	ETF	135.45	135.5	135.38	135.45	3571956.0
2012-07-13 14:30:00	SPY	ETF	135.44	135.53	135.41	135.53	3452587.0
2012-07-13 15:00:00	SPY	ETF	135.53	135.89	135.525	135.69	9984373.0
2012-07-13 15:30:00	SPY	ETF	135.69	135.88	135.58	135.7	24374195.0
2012-07-13 16:00:00	SPY	ETF	135.69	135.85	134.0831	135.73	13212626.0
2012-07-13 16:30:00	SPY	ETF	135.74	135.7993	135.65	135.69	378304.0
2012-07-13 17:00:00	SPY	ETF	135.71	135.74	134.14	135.74	75176.0
2012-07-13 17:30:00	SPY	ETF	135.73	135.73	135.6	135.64	65799.0
2012-07-13 18:00:00	SPY	ETF	135.65	135.69	135.62	135.69	10483.0
2012-07-13 18:30:00	SPY	ETF	135.68	135.68	135.64	135.64	1950.0
2012-07-13 19:00:00	SPY	ETF	135.65	135.68	135.64	135.68	8450.0
2012-07-13 19:30:00	SPY	ETF	135.68	135.68	135.65	135.67	10255.0
2012-07-13 05:00:00	QQQ	ETF	62.64	62.64	62.64	62.64	1600.0
2012-07-13 05:30:00	QQQ	ETF	62.64	62.66	62.64	62.66	5000.0
2012-07-13 06:30:00	QQQ	ETF	62.72	62.72	62.72	62.72	400.0
2012-07-13 07:00:00	QQQ	ETF	62.67	62.69	62.59	62.62	13000.0
2012-07-13 07:30:00	QQQ	ETF	62.62	62.65	62.53	62.53	54960.0
2012-07-13 08:00:00	QQQ	ETF	62.57	62.61	62.5	62.5	857840.0
2012-07-13 08:30:00	QQQ	ETF	62.58	62.66	62.52	62.57	38176.0
2012-07-13 09:00:00	QQQ	ETF	62.54	62.62	62.5	62.56	127498.0
2012-07-13 09:30:00	QQQ	ETF	62.57	62.91	62.56	62.86	4925774.0
2012-07-13 10:00:00	QQQ	ETF	62.86	63.117	62.82	62.98	3948570.0
2012-07-13 10:30:00	QQQ	ETF	62.98	63.15	62.98	63.056	2424741.0
2012-07-13 11:00:00	QQQ	ETF	63.06	63.09	62.97	62.99	1440277.0
2012-07-13 11:30:00	QQQ	ETF	62.99	63.2	62.99	63.191	2532675.0
2012-07-13 12:00:00	QQQ	ETF	63.19	63.3	63.19	63.24	2006587.0
2012-07-13 12:30:00	QQQ	ETF	63.24	63.265	63.22	63.23	1093107.0
2012-07-13 13:00:00	QQQ	ETF	63.22	63.31	63.22	63.258	947842.0
2012-07-13 13:30:00	QQQ	ETF	63.25	63.35	63.2	63.29	945390.0
2012-07-13 14:00:00	QQQ	ETF	63.29	63.34	63.26	63.32	776366.0

> showing 50 of 9,161 rows — these rows as CSV

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