PREVIEW / etf_30min / 2013-03-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-08.parquet
  size:    312 KB
  rows:    10,692

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
2013-03-08 04:00:00	SPY	ETF	155.06	155.21	155.06	155.15	4900.0
2013-03-08 04:30:00	SPY	ETF	155.15	155.17	155.12	155.12	2100.0
2013-03-08 05:00:00	SPY	ETF	155.18	155.18	155.13	155.16	1700.0
2013-03-08 05:30:00	SPY	ETF	155.18	155.3	155.16	155.25	10299.0
2013-03-08 06:00:00	SPY	ETF	155.24	155.24	155.15	155.17	2700.0
2013-03-08 06:30:00	SPY	ETF	155.18	155.3	155.17	155.25	82225.0
2013-03-08 07:00:00	SPY	ETF	155.26	155.28	155.12	155.16	129647.0
2013-03-08 07:30:00	SPY	ETF	155.17	155.2	155.09	155.13	177909.0
2013-03-08 08:00:00	SPY	ETF	155.14	155.21	155.09	155.15	522873.0
2013-03-08 08:30:00	SPY	ETF	155.15	155.78	155.13	155.27	4352212.0
2013-03-08 09:00:00	SPY	ETF	155.27	155.5	154.82	155.46	1111491.0
2013-03-08 09:30:00	SPY	ETF	155.46	155.6	154.91	155.03	16701133.0
2013-03-08 10:00:00	SPY	ETF	155.03	155.03	154.66	154.99	14029228.0
2013-03-08 10:30:00	SPY	ETF	154.9801	155.145	154.9	155.04	7592314.0
2013-03-08 11:00:00	SPY	ETF	155.05	155.2	154.89	155.14	6731042.0
2013-03-08 11:30:00	SPY	ETF	155.14	155.28	155.12	155.2799	5221004.0
2013-03-08 12:00:00	SPY	ETF	155.2799	155.33	155.015	155.03	5211237.0
2013-03-08 12:30:00	SPY	ETF	155.04	155.16	154.94	155.15	5504723.0
2013-03-08 13:00:00	SPY	ETF	155.15	155.26	155.08	155.17	3079734.0
2013-03-08 13:30:00	SPY	ETF	155.179	155.32	155.15	155.29	2937528.0
2013-03-08 14:00:00	SPY	ETF	155.29	155.32	155.21	155.3101	2393436.0
2013-03-08 14:30:00	SPY	ETF	155.3101	155.39	155.24	155.321	2999792.0
2013-03-08 15:00:00	SPY	ETF	155.3201	155.52	155.32	155.47	6980356.0
2013-03-08 15:30:00	SPY	ETF	155.47	155.65	155.39	155.44	19137590.0
2013-03-08 16:00:00	SPY	ETF	155.43	155.5102	154.8634	155.4	10453956.0
2013-03-08 16:30:00	SPY	ETF	155.4	155.5009	154.8089	155.42	1341089.0
2013-03-08 17:00:00	SPY	ETF	155.42	155.53	155.36	155.4	265990.0
2013-03-08 17:30:00	SPY	ETF	155.41	155.48	155.39	155.47	69779.0
2013-03-08 18:00:00	SPY	ETF	155.48	155.48	155.42	155.42	6470.0
2013-03-08 18:30:00	SPY	ETF	155.44	155.45	155.4	155.44	4190.0
2013-03-08 19:00:00	SPY	ETF	155.44	155.44	155.4	155.4	2400.0
2013-03-08 19:30:00	SPY	ETF	155.46	155.5	155.45	155.47	3059.0
2013-03-08 04:00:00	QQQ	ETF	68.79	68.79	68.79	68.79	2400.0
2013-03-08 04:30:00	QQQ	ETF	68.79	68.79	68.79	68.79	2400.0
2013-03-08 06:00:00	QQQ	ETF	68.82	68.83	68.82	68.83	500.0
2013-03-08 06:30:00	QQQ	ETF	68.83	68.86	68.83	68.86	5900.0
2013-03-08 07:00:00	QQQ	ETF	68.86	68.88	68.82	68.82	4600.0
2013-03-08 07:30:00	QQQ	ETF	68.82	68.86	68.77	68.78	345720.0
2013-03-08 08:00:00	QQQ	ETF	68.79	68.81	68.76	68.8	263790.0
2013-03-08 08:30:00	QQQ	ETF	68.9	69.14	68.8	68.88	421564.0
2013-03-08 09:00:00	QQQ	ETF	68.89	68.97	68.87	68.92	392996.0
2013-03-08 09:30:00	QQQ	ETF	68.93	69.02	68.66	68.692	4446014.0
2013-03-08 10:00:00	QQQ	ETF	68.69	68.7	68.5	68.69	3389862.0
2013-03-08 10:30:00	QQQ	ETF	68.69	68.74	68.61	68.68	1813501.0
2013-03-08 11:00:00	QQQ	ETF	68.6818	68.78	68.6	68.73	2406668.0
2013-03-08 11:30:00	QQQ	ETF	68.74	68.78	68.72	68.78	932075.0
2013-03-08 12:00:00	QQQ	ETF	68.77	68.81	68.66	68.66	1232197.0
2013-03-08 12:30:00	QQQ	ETF	68.66	68.69	68.6	68.67	668153.0
2013-03-08 13:00:00	QQQ	ETF	68.67	68.76	68.65	68.71	769753.0
2013-03-08 13:30:00	QQQ	ETF	68.71	68.76	68.7	68.731	664999.0

> showing 50 of 10,692 rows — these rows as CSV

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