PREVIEW / etf_30min / 2011-09-30

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-30.parquet
  size:    289 KB
  rows:    9,660

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-30 04:00:00	SPY	ETF	115.45	115.45	115.2	115.26	3500.0
2011-09-30 04:30:00	SPY	ETF	115.2	115.45	115.17	115.43	32230.0
2011-09-30 05:00:00	SPY	ETF	115.35	115.35	114.95	115.02	24800.0
2011-09-30 05:30:00	SPY	ETF	114.97	115.0	114.79	114.79	24251.0
2011-09-30 06:00:00	SPY	ETF	114.81	115.01	114.54	114.69	49739.0
2011-09-30 06:30:00	SPY	ETF	114.7	114.9	114.55	114.8	513600.0
2011-09-30 07:00:00	SPY	ETF	114.83	115.09	114.67	114.77	246341.0
2011-09-30 07:30:00	SPY	ETF	114.75	115.07	114.65	114.75	344436.0
2011-09-30 08:00:00	SPY	ETF	114.7	115.2	114.6	115.05	1526972.0
2011-09-30 08:30:00	SPY	ETF	115.04	115.17	114.66	114.67	1771141.0
2011-09-30 09:00:00	SPY	ETF	114.67	114.75	114.4	114.44	1787275.0
2011-09-30 09:30:00	SPY	ETF	114.45	115.09	114.05	114.13	41669960.0
2011-09-30 10:00:00	SPY	ETF	114.11	115.34	114.0	114.96	22607283.0
2011-09-30 10:30:00	SPY	ETF	114.96	115.0	114.27	114.33	15154028.0
2011-09-30 11:00:00	SPY	ETF	114.34	115.29	114.32	114.89	13234189.0
2011-09-30 11:30:00	SPY	ETF	114.89	115.45	114.86	115.09	12412613.0
2011-09-30 12:00:00	SPY	ETF	115.1	115.27	114.75	115.0	6782147.0
2011-09-30 12:30:00	SPY	ETF	114.99	115.025	114.62	114.6301	6998322.0
2011-09-30 13:00:00	SPY	ETF	114.64	114.83	114.43	114.69	8590239.0
2011-09-30 13:30:00	SPY	ETF	114.69	115.11	114.68	114.8001	7050463.0
2011-09-30 14:00:00	SPY	ETF	114.8	114.93	113.92	114.128	17285898.0
2011-09-30 14:30:00	SPY	ETF	114.13	114.49	113.78	114.285	21263819.0
2011-09-30 15:00:00	SPY	ETF	114.32	114.67	113.92	113.92	17656331.0
2011-09-30 15:30:00	SPY	ETF	113.93	114.29	113.07	113.15	56168188.0
2011-09-30 16:00:00	SPY	ETF	113.15	116.0183	112.76	112.91	23004843.0
2011-09-30 16:30:00	SPY	ETF	112.91	113.125	112.83	113.03	7507627.0
2011-09-30 17:00:00	SPY	ETF	113.0	113.09	112.95	112.97	583810.0
2011-09-30 17:30:00	SPY	ETF	112.97	113.02	112.9	112.95	179647.0
2011-09-30 18:00:00	SPY	ETF	112.95	113.02	112.91	112.96	126659.0
2011-09-30 18:30:00	SPY	ETF	112.96	112.99	112.88	112.9	69287.0
2011-09-30 19:00:00	SPY	ETF	112.94	113.17	112.83	112.83	162105.0
2011-09-30 19:30:00	SPY	ETF	112.93	112.95	112.83	112.89	39972.0
2011-09-30 04:00:00	QQQ	ETF	53.57	53.57	53.57	53.57	100.0
2011-09-30 05:00:00	QQQ	ETF	53.48	53.48	53.46	53.46	300.0
2011-09-30 06:00:00	QQQ	ETF	53.35	53.35	53.28	53.28	3100.0
2011-09-30 06:30:00	QQQ	ETF	53.25	53.4	53.25	53.35	5500.0
2011-09-30 07:00:00	QQQ	ETF	53.39	53.47	53.27	53.27	38574.0
2011-09-30 07:30:00	QQQ	ETF	53.33	53.42	53.26	53.29	87650.0
2011-09-30 08:00:00	QQQ	ETF	53.29	53.5	53.28	53.42	256759.0
2011-09-30 08:30:00	QQQ	ETF	53.42	53.43	53.26	53.26	112581.0
2011-09-30 09:00:00	QQQ	ETF	53.26	53.27	53.15	53.18	222468.0
2011-09-30 09:30:00	QQQ	ETF	53.19	53.29	52.83	52.92	14496639.0
2011-09-30 10:00:00	QQQ	ETF	52.92	53.59	52.86	53.35	9258676.0
2011-09-30 10:30:00	QQQ	ETF	53.35	53.38	53.02	53.06	6127354.0
2011-09-30 11:00:00	QQQ	ETF	53.06	53.56	53.06	53.35	4248040.0
2011-09-30 11:30:00	QQQ	ETF	53.36	53.61	53.35	53.41	3885318.0
2011-09-30 12:00:00	QQQ	ETF	53.41	53.5	53.2705	53.39	2509238.0
2011-09-30 12:30:00	QQQ	ETF	53.39	53.39	53.16	53.17	3472609.0
2011-09-30 13:00:00	QQQ	ETF	53.16	53.2493	53.05	53.17	3426689.0
2011-09-30 13:30:00	QQQ	ETF	53.17	53.36	53.16	53.225	1876537.0

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

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