PREVIEW / etf_30min / 2012-09-10

all etf 30-min files

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

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-09-10 04:00:00	SPY	ETF	143.99	144.1	143.98	144.08	38043.0
2012-09-10 04:30:00	SPY	ETF	144.11	144.15	144.11	144.12	650.0
2012-09-10 05:00:00	SPY	ETF	144.12	144.12	144.12	144.12	100.0
2012-09-10 05:30:00	SPY	ETF	144.2	144.2	144.19	144.19	258.0
2012-09-10 06:00:00	SPY	ETF	144.2	144.2	144.2	144.2	725.0
2012-09-10 06:30:00	SPY	ETF	144.16	144.18	144.16	144.18	18880.0
2012-09-10 07:00:00	SPY	ETF	144.2	144.2	144.09	144.1	40300.0
2012-09-10 07:30:00	SPY	ETF	144.1	144.2	144.1	144.16	88750.0
2012-09-10 08:00:00	SPY	ETF	144.2	144.22	144.07	144.11	255147.0
2012-09-10 08:30:00	SPY	ETF	144.13	144.16	144.04	144.07	368470.0
2012-09-10 09:00:00	SPY	ETF	144.08	144.21	144.04	144.19	739167.0
2012-09-10 09:30:00	SPY	ETF	144.19	144.28	144.0	144.21	13325826.0
2012-09-10 10:00:00	SPY	ETF	144.2	144.44	144.155	144.372	8372529.0
2012-09-10 10:30:00	SPY	ETF	144.38	144.41	144.19	144.25	4498064.0
2012-09-10 11:00:00	SPY	ETF	144.25	144.38	144.18	144.33	3802840.0
2012-09-10 11:30:00	SPY	ETF	144.325	144.35	144.26	144.29	1793282.0
2012-09-10 12:00:00	SPY	ETF	144.29	144.37	144.17	144.1834	3249653.0
2012-09-10 12:30:00	SPY	ETF	144.18	144.24	144.12	144.23	2819188.0
2012-09-10 13:00:00	SPY	ETF	144.23	144.32	144.21	144.31	2095611.0
2012-09-10 13:30:00	SPY	ETF	144.31	144.34	144.03	144.04	3612129.0
2012-09-10 14:00:00	SPY	ETF	144.05	144.16	144.04	144.11	3513501.0
2012-09-10 14:30:00	SPY	ETF	144.1	144.15	143.92	143.935	4891708.0
2012-09-10 15:00:00	SPY	ETF	143.935	144.3622	143.73	143.85	5497309.0
2012-09-10 15:30:00	SPY	ETF	143.85	143.85	143.46	143.53	14338443.0
2012-09-10 16:00:00	SPY	ETF	143.54	144.1	143.21	143.21	5536072.0
2012-09-10 16:30:00	SPY	ETF	143.21	144.18	143.06	143.1	2068933.0
2012-09-10 17:00:00	SPY	ETF	143.13	143.19	143.1	143.19	1184836.0
2012-09-10 17:30:00	SPY	ETF	143.18	143.18	143.12	143.15	39823.0
2012-09-10 18:00:00	SPY	ETF	143.15	143.27	143.15	143.27	173253.0
2012-09-10 18:30:00	SPY	ETF	143.26	143.27	143.23	143.23	13800.0
2012-09-10 19:00:00	SPY	ETF	143.25	143.28	143.25	143.28	26890.0
2012-09-10 19:30:00	SPY	ETF	143.29	143.3	143.2	143.24	20950.0
2012-09-10 07:00:00	QQQ	ETF	69.23	69.23	69.23	69.23	200.0
2012-09-10 07:30:00	QQQ	ETF	69.24	69.27	69.23	69.27	10800.0
2012-09-10 08:00:00	QQQ	ETF	69.28	69.29	69.22	69.27	171500.0
2012-09-10 08:30:00	QQQ	ETF	69.25	69.28	69.22	69.23	55633.0
2012-09-10 09:00:00	QQQ	ETF	69.23	69.29	69.22	69.27	67928.0
2012-09-10 09:30:00	QQQ	ETF	69.26	69.4	69.13	69.16	3931327.0
2012-09-10 10:00:00	QQQ	ETF	69.16	69.2699	69.1	69.1801	2547004.0
2012-09-10 10:30:00	QQQ	ETF	69.18	69.2	68.96	69.04	2176662.0
2012-09-10 11:00:00	QQQ	ETF	69.04	69.14	68.99	69.07	918904.0
2012-09-10 11:30:00	QQQ	ETF	69.07	69.15	69.03	69.12	451771.0
2012-09-10 12:00:00	QQQ	ETF	69.13	69.14	68.97	68.99	775453.0
2012-09-10 12:30:00	QQQ	ETF	68.99	69.05	68.94	69.0283	851806.0
2012-09-10 13:00:00	QQQ	ETF	69.02	69.08	69.0	69.05	458050.0
2012-09-10 13:30:00	QQQ	ETF	69.041	69.07	68.83	68.835	982184.0
2012-09-10 14:00:00	QQQ	ETF	68.83	68.9	68.83	68.85	687344.0
2012-09-10 14:30:00	QQQ	ETF	68.86	68.8898	68.65	68.6517	2924275.0
2012-09-10 15:00:00	QQQ	ETF	68.651	68.74	68.61	68.71	3026052.0
2012-09-10 15:30:00	QQQ	ETF	68.71	68.72	68.49	68.55	3848234.0

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

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