PREVIEW / etf_30min / 2011-09-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-08.parquet
  size:    277 KB
  rows:    9,191

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-08 04:00:00	SPY	ETF	120.01	120.1	119.88	120.1	9831.0
2011-09-08 04:30:00	SPY	ETF	120.32	120.4	120.32	120.4	700.0
2011-09-08 05:00:00	SPY	ETF	120.4	120.4	120.4	120.4	300.0
2011-09-08 05:30:00	SPY	ETF	120.52	120.52	120.52	120.52	100.0
2011-09-08 06:00:00	SPY	ETF	120.65	120.8	120.65	120.74	16680.0
2011-09-08 06:30:00	SPY	ETF	120.65	120.65	120.4	120.6	15920.0
2011-09-08 07:00:00	SPY	ETF	120.42	120.59	120.37	120.4	232140.0
2011-09-08 07:30:00	SPY	ETF	120.38	120.54	119.87	119.97	682870.0
2011-09-08 08:00:00	SPY	ETF	119.99	120.5	119.51	119.57	1924764.0
2011-09-08 08:30:00	SPY	ETF	119.66	119.91	119.16	119.53	4695696.0
2011-09-08 09:00:00	SPY	ETF	119.52	119.73	119.42	119.56	1738925.0
2011-09-08 09:30:00	SPY	ETF	119.57	120.37	119.41	119.77	27692138.0
2011-09-08 10:00:00	SPY	ETF	119.77	120.26	119.38	120.06	17383887.0
2011-09-08 10:30:00	SPY	ETF	120.06	120.76	120.05	120.73	14771898.0
2011-09-08 11:00:00	SPY	ETF	120.73	120.94	120.41	120.44	13522707.0
2011-09-08 11:30:00	SPY	ETF	120.44	120.71	119.91	120.021	18674243.0
2011-09-08 12:00:00	SPY	ETF	120.02	120.25	119.8	120.01	9561000.0
2011-09-08 12:30:00	SPY	ETF	120.0123	120.35	119.79	120.31	7721728.0
2011-09-08 13:00:00	SPY	ETF	120.32	120.39	119.99	120.07	7149728.0
2011-09-08 13:30:00	SPY	ETF	120.06	120.36	119.1	119.41	27504918.0
2011-09-08 14:00:00	SPY	ETF	119.41	119.72	119.0	119.18	17449781.0
2011-09-08 14:30:00	SPY	ETF	119.17	119.5	119.04	119.32	14793657.0
2011-09-08 15:00:00	SPY	ETF	119.33	119.38	118.77	119.37	22646570.0
2011-09-08 15:30:00	SPY	ETF	119.37	119.59	119.03	119.03	24376496.0
2011-09-08 16:00:00	SPY	ETF	119.02	120.783	118.89	119.1	8540625.0
2011-09-08 16:30:00	SPY	ETF	119.11	119.12	118.91	119.09	1164952.0
2011-09-08 17:00:00	SPY	ETF	119.1	119.22	119.08	119.18	813297.0
2011-09-08 17:30:00	SPY	ETF	119.12	119.16	119.06	119.07	33063.0
2011-09-08 18:00:00	SPY	ETF	119.07	119.38	119.02	119.06	266843.0
2011-09-08 18:30:00	SPY	ETF	119.06	119.34	119.06	119.32	131976.0
2011-09-08 19:00:00	SPY	ETF	119.31	119.39	118.9	118.97	253585.0
2011-09-08 19:30:00	SPY	ETF	118.99	119.15	118.53	118.8	391416.0
2011-09-08 05:30:00	QQQ	ETF	54.81	54.85	54.81	54.83	1400.0
2011-09-08 07:00:00	QQQ	ETF	54.75	54.83	54.75	54.83	5900.0
2011-09-08 07:30:00	QQQ	ETF	54.73	54.78	54.53	54.54	36000.0
2011-09-08 08:00:00	QQQ	ETF	54.57	54.58	54.46	54.47	103526.0
2011-09-08 08:30:00	QQQ	ETF	54.44	54.54	54.22	54.38	1011831.0
2011-09-08 09:00:00	QQQ	ETF	54.36	54.48	54.33	54.36	682260.0
2011-09-08 09:30:00	QQQ	ETF	54.36	54.75	54.35	54.53	7086445.0
2011-09-08 10:00:00	QQQ	ETF	54.52	54.9	54.33	54.82	4538424.0
2011-09-08 10:30:00	QQQ	ETF	54.82	55.1	54.81	55.08	3160835.0
2011-09-08 11:00:00	QQQ	ETF	55.08	55.1684	54.91	54.91	2782710.0
2011-09-08 11:30:00	QQQ	ETF	54.91	55.05	54.67	54.71	3599000.0
2011-09-08 12:00:00	QQQ	ETF	54.71	54.86	54.63	54.72	2213772.0
2011-09-08 12:30:00	QQQ	ETF	54.72	54.82	54.56	54.8	2105401.0
2011-09-08 13:00:00	QQQ	ETF	54.8	54.82	54.65	54.7	1335914.0
2011-09-08 13:30:00	QQQ	ETF	54.7099	54.85	54.33	54.5	5537241.0
2011-09-08 14:00:00	QQQ	ETF	54.4901	54.64	54.33	54.42	3777135.0
2011-09-08 14:30:00	QQQ	ETF	54.41	54.56	54.36	54.51	2386911.0
2011-09-08 15:00:00	QQQ	ETF	54.501	54.53	54.21	54.52	3480397.0

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

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