PREVIEW / etf_30min / 2011-09-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-23.parquet
  size:    295 KB
  rows:    9,951

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-09-23 04:00:00	SPY	ETF	113.66	114.04	113.66	114.03	6347.0
2011-09-23 04:30:00	SPY	ETF	114.12	114.23	114.04	114.04	3080.0
2011-09-23 05:00:00	SPY	ETF	114.2	114.23	113.5	113.5	1127.0
2011-09-23 05:30:00	SPY	ETF	113.69	113.69	113.02	113.02	5700.0
2011-09-23 06:00:00	SPY	ETF	113.28	113.28	112.24	112.24	20852.0
2011-09-23 06:30:00	SPY	ETF	112.32	112.43	111.75	112.25	273667.0
2011-09-23 07:00:00	SPY	ETF	112.2	112.35	111.82	111.97	2147221.0
2011-09-23 07:30:00	SPY	ETF	112.0	112.08	111.16	111.28	1114934.0
2011-09-23 08:00:00	SPY	ETF	111.32	114.33	110.85	112.21	6301615.0
2011-09-23 08:30:00	SPY	ETF	112.22	112.22	111.4	111.76	4448278.0
2011-09-23 09:00:00	SPY	ETF	111.75	113.17	111.7	112.11	6030654.0
2011-09-23 09:30:00	SPY	ETF	112.11	113.47	112.02	113.1	38461849.0
2011-09-23 10:00:00	SPY	ETF	113.1	113.2905	112.12	112.77	28297010.0
2011-09-23 10:30:00	SPY	ETF	112.78	113.66	112.67	113.51	26770264.0
2011-09-23 11:00:00	SPY	ETF	113.52	114.03	113.21	113.79	20690166.0
2011-09-23 11:30:00	SPY	ETF	113.8	113.83	113.1	113.467	13710231.0
2011-09-23 12:00:00	SPY	ETF	113.46	113.78	113.185	113.34	8952728.0
2011-09-23 12:30:00	SPY	ETF	113.34	113.72	112.87	113.13	22304579.0
2011-09-23 13:00:00	SPY	ETF	113.13	113.33	112.8	113.08	15695693.0
2011-09-23 13:30:00	SPY	ETF	113.08	114.01	113.0	113.95	18345487.0
2011-09-23 14:00:00	SPY	ETF	113.95	114.16	113.11	113.2	15776075.0
2011-09-23 14:30:00	SPY	ETF	113.19	113.48	112.86	112.93	13494423.0
2011-09-23 15:00:00	SPY	ETF	112.93	113.73	112.93	113.72	15064832.0
2011-09-23 15:30:00	SPY	ETF	113.72	113.85	113.18	113.44	28465522.0
2011-09-23 16:00:00	SPY	ETF	113.43	113.71	112.97	113.7	9349218.0
2011-09-23 16:30:00	SPY	ETF	113.71	113.8	112.8995	113.64	3958098.0
2011-09-23 17:00:00	SPY	ETF	113.66	113.68	113.22	113.26	1939991.0
2011-09-23 17:30:00	SPY	ETF	113.27	113.3	113.14	113.15	336526.0
2011-09-23 18:00:00	SPY	ETF	113.15	113.54	113.01	113.23	983561.0
2011-09-23 18:30:00	SPY	ETF	113.23	113.23	113.16	113.23	14085.0
2011-09-23 19:00:00	SPY	ETF	113.23	113.35	113.2	113.34	31661.0
2011-09-23 19:30:00	SPY	ETF	113.33	113.44	113.26	113.44	30407.0
2011-09-23 04:30:00	QQQ	ETF	53.88	53.88	53.88	53.88	800.0
2011-09-23 05:00:00	QQQ	ETF	53.88	53.88	53.84	53.84	2000.0
2011-09-23 06:00:00	QQQ	ETF	53.51	53.51	53.51	53.51	1000.0
2011-09-23 06:30:00	QQQ	ETF	53.13	53.13	52.86	52.86	13622.0
2011-09-23 07:00:00	QQQ	ETF	53.02	53.13	52.93	53.0	107915.0
2011-09-23 07:30:00	QQQ	ETF	53.05	53.05	52.6	52.66	97084.0
2011-09-23 08:00:00	QQQ	ETF	52.68	53.16	52.5	53.13	2149416.0
2011-09-23 08:30:00	QQQ	ETF	53.13	53.13	52.81	52.94	367189.0
2011-09-23 09:00:00	QQQ	ETF	52.93	53.52	52.93	53.14	1046608.0
2011-09-23 09:30:00	QQQ	ETF	53.14	53.84	53.091	53.641	12148783.0
2011-09-23 10:00:00	QQQ	ETF	53.65	53.77	53.4	53.67	7162382.0
2011-09-23 10:30:00	QQQ	ETF	53.67	54.01	53.6	53.95	5810866.0
2011-09-23 11:00:00	QQQ	ETF	53.95	54.27	53.81	54.1893	5021431.0
2011-09-23 11:30:00	QQQ	ETF	54.2	54.215	53.79	53.98	2871278.0
2011-09-23 12:00:00	QQQ	ETF	53.981	54.13	53.83	53.91	2240847.0
2011-09-23 12:30:00	QQQ	ETF	53.91	54.07	53.69	53.8	4641764.0
2011-09-23 13:00:00	QQQ	ETF	53.81	53.98	53.71	53.878	2997679.0
2011-09-23 13:30:00	QQQ	ETF	53.89	54.3099	53.85	54.28	6362946.0

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

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