PREVIEW / etf_30min / 2011-10-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-14.parquet
  size:    283 KB
  rows:    9,378

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
2011-10-14 04:00:00	SPY	ETF	120.37	121.12	120.37	121.12	59750.0
2011-10-14 04:30:00	SPY	ETF	121.08	121.29	121.02	121.27	35350.0
2011-10-14 05:00:00	SPY	ETF	121.18	121.24	121.1	121.24	30750.0
2011-10-14 05:30:00	SPY	ETF	121.22	121.52	121.22	121.49	146043.0
2011-10-14 06:00:00	SPY	ETF	121.4	121.52	121.4	121.42	57700.0
2011-10-14 06:30:00	SPY	ETF	121.47	121.5	121.31	121.44	86900.0
2011-10-14 07:00:00	SPY	ETF	121.39	121.41	121.11	121.26	1055900.0
2011-10-14 07:30:00	SPY	ETF	121.27	121.5	121.16	121.41	972226.0
2011-10-14 08:00:00	SPY	ETF	121.41	121.63	121.14	121.63	2975318.0
2011-10-14 08:30:00	SPY	ETF	121.63	122.0	120.47	121.66	4286265.0
2011-10-14 09:00:00	SPY	ETF	121.66	122.11	120.47	121.92	2920392.0
2011-10-14 09:30:00	SPY	ETF	121.91	122.28	121.83	121.99	30140485.0
2011-10-14 10:00:00	SPY	ETF	122.0	122.06	121.48	121.49	20357998.0
2011-10-14 10:30:00	SPY	ETF	121.49	121.8	121.44	121.75	14750159.0
2011-10-14 11:00:00	SPY	ETF	121.75	121.85	121.26	121.32	13094772.0
2011-10-14 11:30:00	SPY	ETF	121.33	121.58	121.29	121.371	8523421.0
2011-10-14 12:00:00	SPY	ETF	121.371	121.48	121.23	121.42	6405495.0
2011-10-14 12:30:00	SPY	ETF	121.4135	121.619	121.38	121.5	5684313.0
2011-10-14 13:00:00	SPY	ETF	121.499	121.82	121.49	121.66	6729968.0
2011-10-14 13:30:00	SPY	ETF	121.65	121.95	121.58	121.92	7609796.0
2011-10-14 14:00:00	SPY	ETF	121.92	121.97	121.3	121.89	5854843.0
2011-10-14 14:30:00	SPY	ETF	121.89	122.12	121.67	122.1	7991054.0
2011-10-14 15:00:00	SPY	ETF	122.1	122.23	121.91	122.215	11614294.0
2011-10-14 15:30:00	SPY	ETF	122.205	122.6	121.94	122.58	33555482.0
2011-10-14 16:00:00	SPY	ETF	122.57	122.69	120.4565	122.62	15156317.0
2011-10-14 16:30:00	SPY	ETF	122.62	122.74	120.4565	122.7	5135872.0
2011-10-14 17:00:00	SPY	ETF	122.71	122.75	120.4566	122.73	2921087.0
2011-10-14 17:30:00	SPY	ETF	122.72	122.73	122.65	122.7	1686274.0
2011-10-14 18:00:00	SPY	ETF	122.7	122.76	122.56	122.76	156827.0
2011-10-14 18:30:00	SPY	ETF	122.73	122.75	122.69	122.69	14560.0
2011-10-14 19:00:00	SPY	ETF	122.69	122.75	122.68	122.75	48031.0
2011-10-14 19:30:00	SPY	ETF	122.76	122.76	122.71	122.73	39481.0
2011-10-14 04:00:00	QQQ	ETF	57.37	57.57	57.37	57.57	1000.0
2011-10-14 05:00:00	QQQ	ETF	57.57	57.59	57.56	57.59	807.0
2011-10-14 05:30:00	QQQ	ETF	57.64	57.7	57.64	57.65	3000.0
2011-10-14 06:00:00	QQQ	ETF	57.63	57.63	57.63	57.63	200.0
2011-10-14 06:30:00	QQQ	ETF	57.65	57.65	57.57	57.57	800.0
2011-10-14 07:00:00	QQQ	ETF	57.62	57.62	57.48	57.55	47017.0
2011-10-14 07:30:00	QQQ	ETF	57.52	57.62	57.51	57.62	97630.0
2011-10-14 08:00:00	QQQ	ETF	57.6	57.74	57.52	57.71	1699323.0
2011-10-14 08:30:00	QQQ	ETF	57.75	57.88	57.73	57.77	1926487.0
2011-10-14 09:00:00	QQQ	ETF	57.76	57.94	57.76	57.84	789831.0
2011-10-14 09:30:00	QQQ	ETF	57.84	58.04	57.82	57.94	11391531.0
2011-10-14 10:00:00	QQQ	ETF	57.93	58.03	57.73	57.74	5693037.0
2011-10-14 10:30:00	QQQ	ETF	57.73	57.86	57.69	57.83	3755851.0
2011-10-14 11:00:00	QQQ	ETF	57.83	57.91	57.51	57.55	5158527.0
2011-10-14 11:30:00	QQQ	ETF	57.54	57.7	57.53	57.64	4595695.0
2011-10-14 12:00:00	QQQ	ETF	57.6307	57.66	57.55	57.63	1587892.0
2011-10-14 12:30:00	QQQ	ETF	57.64	57.74	57.6201	57.64	2038885.0
2011-10-14 13:00:00	QQQ	ETF	57.64	57.8	57.64	57.725	1800962.0

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

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