PREVIEW / etf_30min / 2012-01-25

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-25.parquet
  size:    298 KB
  rows:    9,840

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-01-25 04:00:00	SPY	ETF	131.89	131.89	131.5	131.51	11855.0
2012-01-25 04:30:00	SPY	ETF	131.55	131.55	131.32	131.37	13178.0
2012-01-25 05:00:00	SPY	ETF	131.33	131.34	131.29	131.34	5800.0
2012-01-25 05:30:00	SPY	ETF	131.37	131.37	131.16	131.17	10384.0
2012-01-25 06:00:00	SPY	ETF	131.09	131.18	131.09	131.13	8785.0
2012-01-25 06:30:00	SPY	ETF	131.18	131.24	131.11	131.19	40904.0
2012-01-25 07:00:00	SPY	ETF	131.2	131.27	131.1	131.15	195973.0
2012-01-25 07:30:00	SPY	ETF	131.14	131.25	130.99	131.17	206365.0
2012-01-25 08:00:00	SPY	ETF	131.17	131.79	131.13	131.28	418398.0
2012-01-25 08:30:00	SPY	ETF	131.28	131.33	131.21	131.22	308606.0
2012-01-25 09:00:00	SPY	ETF	131.22	131.33	131.09	131.26	893867.0
2012-01-25 09:30:00	SPY	ETF	131.26	131.26	130.78	130.86	14431862.0
2012-01-25 10:00:00	SPY	ETF	130.86	131.19	130.75	131.1	12853717.0
2012-01-25 10:30:00	SPY	ETF	131.09	131.23	130.92	131.18	6265895.0
2012-01-25 11:00:00	SPY	ETF	131.19	131.42	131.18	131.33	7550781.0
2012-01-25 11:30:00	SPY	ETF	131.34	131.38	131.2	131.3	4869126.0
2012-01-25 12:00:00	SPY	ETF	131.3	131.56	131.04	131.34	11697845.0
2012-01-25 12:30:00	SPY	ETF	131.34	131.74	131.1	131.51	20766728.0
2012-01-25 13:00:00	SPY	ETF	131.5	132.23	131.47	132.12	15371330.0
2012-01-25 13:30:00	SPY	ETF	132.1117	132.5	132.07	132.46	10334618.0
2012-01-25 14:00:00	SPY	ETF	132.47	132.49	131.88	131.99	17427550.0
2012-01-25 14:30:00	SPY	ETF	131.99	132.43	131.9728	132.28	11437508.0
2012-01-25 15:00:00	SPY	ETF	132.275	132.59	132.16	132.529	10042180.0
2012-01-25 15:30:00	SPY	ETF	132.53	132.87	132.51	132.57	26946568.0
2012-01-25 16:00:00	SPY	ETF	132.58	132.63	131.21	132.52	13183037.0
2012-01-25 16:30:00	SPY	ETF	132.5	132.6199	131.4816	132.49	6823551.0
2012-01-25 17:00:00	SPY	ETF	132.57	132.57	131.4812	132.51	4222676.0
2012-01-25 17:30:00	SPY	ETF	132.52	132.57	132.52	132.55	38898.0
2012-01-25 18:00:00	SPY	ETF	132.52	132.53	132.41	132.42	141463.0
2012-01-25 18:30:00	SPY	ETF	132.42	132.42	132.31	132.31	99338.0
2012-01-25 19:00:00	SPY	ETF	132.31	132.35	132.28	132.35	42800.0
2012-01-25 19:30:00	SPY	ETF	132.35	132.41	132.34	132.38	129766.0
2012-01-25 04:00:00	QQQ	ETF	60.29	60.29	60.26	60.26	2000.0
2012-01-25 04:30:00	QQQ	ETF	60.24	60.24	60.15	60.17	8800.0
2012-01-25 05:00:00	QQQ	ETF	60.21	60.21	60.2	60.21	3300.0
2012-01-25 05:30:00	QQQ	ETF	60.2	60.2	60.08	60.08	7600.0
2012-01-25 06:00:00	QQQ	ETF	60.07	60.11	60.05	60.11	8700.0
2012-01-25 06:30:00	QQQ	ETF	60.12	60.18	60.1	60.17	50800.0
2012-01-25 07:00:00	QQQ	ETF	60.16	60.22	60.15	60.18	39275.0
2012-01-25 07:30:00	QQQ	ETF	60.18	60.26	60.15	60.24	53050.0
2012-01-25 08:00:00	QQQ	ETF	60.17	60.28	60.16	60.28	165401.0
2012-01-25 08:30:00	QQQ	ETF	60.26	60.34	60.26	60.3	339912.0
2012-01-25 09:00:00	QQQ	ETF	60.3	60.37	60.26	60.28	519882.0
2012-01-25 09:30:00	QQQ	ETF	60.29	60.3	59.91	59.96	7346255.0
2012-01-25 10:00:00	QQQ	ETF	59.965	60.06	59.88	59.94	6687405.0
2012-01-25 10:30:00	QQQ	ETF	59.945	60.03	59.8335	60.01	3576638.0
2012-01-25 11:00:00	QQQ	ETF	60.02	60.19	60.0	60.14	3030143.0
2012-01-25 11:30:00	QQQ	ETF	60.14	60.18	60.05	60.15	1133111.0
2012-01-25 12:00:00	QQQ	ETF	60.14	60.2	59.98	60.1	3929374.0
2012-01-25 12:30:00	QQQ	ETF	60.11	60.27	60.01	60.02	5277497.0

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

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