PREVIEW / etf_30min / 2011-10-13

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-13.parquet
  size:    279 KB
  rows:    9,372

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-13 04:00:00	SPY	ETF	120.45	120.75	120.13	120.13	18140.0
2011-10-13 04:30:00	SPY	ETF	120.06	120.08	119.93	120.04	79055.0
2011-10-13 05:00:00	SPY	ETF	120.15	120.18	120.02	120.02	5400.0
2011-10-13 05:30:00	SPY	ETF	120.04	120.04	119.75	119.77	87825.0
2011-10-13 06:00:00	SPY	ETF	119.92	119.92	119.68	119.82	124200.0
2011-10-13 06:30:00	SPY	ETF	119.89	120.25	119.71	120.11	187805.0
2011-10-13 07:00:00	SPY	ETF	120.18	120.18	119.64	120.03	363129.0
2011-10-13 07:30:00	SPY	ETF	119.99	119.99	119.72	119.76	994731.0
2011-10-13 08:00:00	SPY	ETF	119.76	120.01	119.56	119.85	2596094.0
2011-10-13 08:30:00	SPY	ETF	119.85	120.03	119.63	119.95	1166028.0
2011-10-13 09:00:00	SPY	ETF	119.95	120.1	119.8406	120.0	1880321.0
2011-10-13 09:30:00	SPY	ETF	120.04	120.07	119.42	119.53	28179503.0
2011-10-13 10:00:00	SPY	ETF	119.561	119.84	119.32	119.68	22289865.0
2011-10-13 10:30:00	SPY	ETF	119.67	119.96	119.18	119.18	18617965.0
2011-10-13 11:00:00	SPY	ETF	119.18	119.5898	119.12	119.34	17854860.0
2011-10-13 11:30:00	SPY	ETF	119.34	119.87	119.32	119.659	12393443.0
2011-10-13 12:00:00	SPY	ETF	119.66	119.83	119.43	119.44	7125468.0
2011-10-13 12:30:00	SPY	ETF	119.44	119.74	119.32	119.67	5696727.0
2011-10-13 13:00:00	SPY	ETF	119.66	120.21	119.45	120.145	15133444.0
2011-10-13 13:30:00	SPY	ETF	120.14	120.36	120.04	120.14	11002477.0
2011-10-13 14:00:00	SPY	ETF	120.14	120.31	119.91	120.02	8947253.0
2011-10-13 14:30:00	SPY	ETF	120.02	120.66	119.965	120.5	10885858.0
2011-10-13 15:00:00	SPY	ETF	120.5	120.87	120.18	120.22	16941063.0
2011-10-13 15:30:00	SPY	ETF	120.22	120.59	120.01	120.48	23130939.0
2011-10-13 16:00:00	SPY	ETF	120.48	120.75	119.8802	120.38	4445451.0
2011-10-13 16:30:00	SPY	ETF	120.35	120.4	120.27	120.39	428709.0
2011-10-13 17:00:00	SPY	ETF	120.38	120.54	120.38	120.49	113196.0
2011-10-13 17:30:00	SPY	ETF	120.49	120.52	120.46	120.5	65810.0
2011-10-13 18:00:00	SPY	ETF	120.48	120.49	120.42	120.44	190165.0
2011-10-13 18:30:00	SPY	ETF	120.43	120.54	120.11	120.15	166551.0
2011-10-13 19:00:00	SPY	ETF	120.15	120.31	120.12	120.2	93865.0
2011-10-13 19:30:00	SPY	ETF	120.21	120.25	120.12	120.22	130970.0
2011-10-13 05:30:00	QQQ	ETF	56.38	56.38	56.26	56.3	2460.0
2011-10-13 06:00:00	QQQ	ETF	56.38	56.41	56.31	56.31	51200.0
2011-10-13 06:30:00	QQQ	ETF	56.38	56.51	56.3	56.51	18800.0
2011-10-13 07:00:00	QQQ	ETF	56.42	56.47	56.31	56.47	52400.0
2011-10-13 07:30:00	QQQ	ETF	56.49	56.49	56.3	56.36	258022.0
2011-10-13 08:00:00	QQQ	ETF	56.35	56.49	56.29	56.45	1042601.0
2011-10-13 08:30:00	QQQ	ETF	56.47	56.49	56.31	56.46	202540.0
2011-10-13 09:00:00	QQQ	ETF	56.47	56.54	56.42	56.48	237418.0
2011-10-13 09:30:00	QQQ	ETF	56.49	56.68	56.43	56.54	8538590.0
2011-10-13 10:00:00	QQQ	ETF	56.54	56.75	56.47	56.68	6864323.0
2011-10-13 10:30:00	QQQ	ETF	56.68	56.79	56.47	56.49	4330462.0
2011-10-13 11:00:00	QQQ	ETF	56.5	56.67	56.47	56.59	3611661.0
2011-10-13 11:30:00	QQQ	ETF	56.59	56.89	56.58	56.8095	4482632.0
2011-10-13 12:00:00	QQQ	ETF	56.8	56.86	56.67	56.67	2354895.0
2011-10-13 12:30:00	QQQ	ETF	56.68	56.78	56.63	56.73	1535253.0
2011-10-13 13:00:00	QQQ	ETF	56.73	56.91	56.6	56.8816	3511411.0
2011-10-13 13:30:00	QQQ	ETF	56.88	56.97	56.8	56.84	2418672.0
2011-10-13 14:00:00	QQQ	ETF	56.8363	56.92	56.75	56.86	1721539.0

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

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