PREVIEW / etf_30min / 2012-10-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-24.parquet
  size:    283 KB
  rows:    9,607

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-10-24 04:00:00	SPY	ETF	141.27	141.3	141.22	141.3	2076.0
2012-10-24 04:30:00	SPY	ETF	141.34	141.6	141.34	141.6	10200.0
2012-10-24 05:00:00	SPY	ETF	141.58	141.69	141.58	141.65	55300.0
2012-10-24 05:30:00	SPY	ETF	141.63	141.65	141.63	141.65	6000.0
2012-10-24 06:00:00	SPY	ETF	141.61	141.82	141.54	141.82	9850.0
2012-10-24 06:30:00	SPY	ETF	141.78	141.78	141.69	141.74	8433.0
2012-10-24 07:00:00	SPY	ETF	141.69	141.72	141.5	141.62	69090.0
2012-10-24 07:30:00	SPY	ETF	141.62	141.8	141.59	141.78	956009.0
2012-10-24 08:00:00	SPY	ETF	141.79	141.95	141.69	141.91	1375383.0
2012-10-24 08:30:00	SPY	ETF	141.91	141.94	141.75	141.92	518965.0
2012-10-24 09:00:00	SPY	ETF	141.91	142.12	141.89	141.94	872815.0
2012-10-24 09:30:00	SPY	ETF	141.93	142.1	141.58	141.74	12246436.0
2012-10-24 10:00:00	SPY	ETF	141.74	141.84	141.37	141.48	10064049.0
2012-10-24 10:30:00	SPY	ETF	141.48	141.8	141.36	141.67	7838489.0
2012-10-24 11:00:00	SPY	ETF	141.67	141.81	141.43	141.58	6857191.0
2012-10-24 11:30:00	SPY	ETF	141.59	141.64	141.27	141.31	5551793.0
2012-10-24 12:00:00	SPY	ETF	141.3	141.45	141.24	141.43	4181553.0
2012-10-24 12:30:00	SPY	ETF	141.4255	141.69	141.4198	141.66	4928650.0
2012-10-24 13:00:00	SPY	ETF	141.655	141.72	141.5	141.6	4258499.0
2012-10-24 13:30:00	SPY	ETF	141.6	141.62	141.49	141.55	2653404.0
2012-10-24 14:00:00	SPY	ETF	141.555	141.75	141.13	141.66	8937015.0
2012-10-24 14:30:00	SPY	ETF	141.66	141.71	141.27	141.27	6624695.0
2012-10-24 15:00:00	SPY	ETF	141.27	141.38	140.86	141.11	11601048.0
2012-10-24 15:30:00	SPY	ETF	141.11	141.12	140.8	141.01	16165313.0
2012-10-24 16:00:00	SPY	ETF	141.01	141.4144	140.95	141.25	5555136.0
2012-10-24 16:30:00	SPY	ETF	141.26	141.6157	141.26	141.29	5710799.0
2012-10-24 17:00:00	SPY	ETF	141.29	141.33	141.29	141.29	988750.0
2012-10-24 17:30:00	SPY	ETF	141.28	141.31	141.25	141.31	37372.0
2012-10-24 18:00:00	SPY	ETF	141.31	141.34	141.28	141.28	42005.0
2012-10-24 18:30:00	SPY	ETF	141.28	141.28	141.15	141.2	75227.0
2012-10-24 19:00:00	SPY	ETF	141.19	141.21	141.12	141.12	28305.0
2012-10-24 19:30:00	SPY	ETF	141.14	141.16	141.13	141.14	106433.0
2012-10-24 04:00:00	QQQ	ETF	65.37	65.39	65.33	65.33	2087.0
2012-10-24 04:30:00	QQQ	ETF	65.51	65.51	65.51	65.51	100.0
2012-10-24 05:30:00	QQQ	ETF	65.49	65.49	65.49	65.49	5000.0
2012-10-24 06:00:00	QQQ	ETF	65.59	65.59	65.59	65.59	100.0
2012-10-24 06:30:00	QQQ	ETF	65.58	65.58	65.56	65.56	30000.0
2012-10-24 07:00:00	QQQ	ETF	65.54	65.55	65.48	65.55	48500.0
2012-10-24 07:30:00	QQQ	ETF	65.59	65.6	65.52	65.6	7420.0
2012-10-24 08:00:00	QQQ	ETF	65.62	65.72	65.33	65.66	175896.0
2012-10-24 08:30:00	QQQ	ETF	65.64	65.7	65.63	65.7	89860.0
2012-10-24 09:00:00	QQQ	ETF	65.69	65.89	65.68	65.76	454660.0
2012-10-24 09:30:00	QQQ	ETF	65.76	65.87	65.53	65.67	3850793.0
2012-10-24 10:00:00	QQQ	ETF	65.66	65.72	65.43	65.465	3123928.0
2012-10-24 10:30:00	QQQ	ETF	65.46	65.55	65.36	65.385	2243499.0
2012-10-24 11:00:00	QQQ	ETF	65.3801	65.47	65.22	65.33	1951961.0
2012-10-24 11:30:00	QQQ	ETF	65.33	65.36	65.13	65.1601	1455749.0
2012-10-24 12:00:00	QQQ	ETF	65.16	65.285	65.1	65.235	1547738.0
2012-10-24 12:30:00	QQQ	ETF	65.23	65.43	65.23	65.39	1528594.0
2012-10-24 13:00:00	QQQ	ETF	65.395	65.43	65.29	65.36	902200.0

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

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