PREVIEW / etf_30min / 2013-05-21

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-05-21.parquet
  size:    315 KB
  rows:    10,703

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-05-21 04:00:00	SPY	ETF	167.05	167.11	166.99	167.06	35800.0
2013-05-21 04:30:00	SPY	ETF	166.91	166.94	166.83	166.84	21960.0
2013-05-21 05:00:00	SPY	ETF	166.78	166.83	166.76	166.78	33207.0
2013-05-21 05:30:00	SPY	ETF	166.73	166.75	166.65	166.72	7100.0
2013-05-21 06:00:00	SPY	ETF	166.75	166.87	166.75	166.85	12170.0
2013-05-21 06:30:00	SPY	ETF	166.83	166.88	166.82	166.83	22400.0
2013-05-21 07:00:00	SPY	ETF	166.85	166.85	166.62	166.78	54594.0
2013-05-21 07:30:00	SPY	ETF	166.73	166.85	166.72	166.84	79598.0
2013-05-21 08:00:00	SPY	ETF	166.85	167.01	166.85	166.99	148593.0
2013-05-21 08:30:00	SPY	ETF	166.98	167.08	166.93	167.07	271653.0
2013-05-21 09:00:00	SPY	ETF	167.07	167.21	167.03	167.08	605275.0
2013-05-21 09:30:00	SPY	ETF	167.08	167.52	167.01	167.34	10536102.0
2013-05-21 10:00:00	SPY	ETF	167.34	167.42	166.59	166.741	11632898.0
2013-05-21 10:30:00	SPY	ETF	166.74	166.79	166.5	166.705	7082085.0
2013-05-21 11:00:00	SPY	ETF	166.71	166.95	166.7	166.8099	5844922.0
2013-05-21 11:30:00	SPY	ETF	166.8	167.2	166.78	167.085	5107596.0
2013-05-21 12:00:00	SPY	ETF	167.09	167.4	167.09	167.35	3806943.0
2013-05-21 12:30:00	SPY	ETF	167.35	167.38	167.2	167.32	3255891.0
2013-05-21 13:00:00	SPY	ETF	167.33	167.76	167.31	167.5265	7102122.0
2013-05-21 13:30:00	SPY	ETF	167.53	167.59	167.42	167.51	2639507.0
2013-05-21 14:00:00	SPY	ETF	167.505	167.8	167.48	167.55	5647685.0
2013-05-21 14:30:00	SPY	ETF	167.54	167.56	167.31	167.4808	4593259.0
2013-05-21 15:00:00	SPY	ETF	167.483	167.59	167.33	167.35	6127554.0
2013-05-21 15:30:00	SPY	ETF	167.34	167.46	167.14	167.19	9828341.0
2013-05-21 16:00:00	SPY	ETF	167.18	167.4727	166.6199	167.1	5982385.0
2013-05-21 16:30:00	SPY	ETF	167.09	167.15	166.731	167.07	771866.0
2013-05-21 17:00:00	SPY	ETF	167.09	167.1	167.06	167.09	32000.0
2013-05-21 17:30:00	SPY	ETF	167.1	167.12	167.05	167.09	67517.0
2013-05-21 18:00:00	SPY	ETF	167.09	167.11	167.06	167.08	64310.0
2013-05-21 18:30:00	SPY	ETF	167.08	167.12	167.08	167.1	5300.0
2013-05-21 19:00:00	SPY	ETF	167.12	167.13	167.09	167.09	9572.0
2013-05-21 19:30:00	SPY	ETF	167.1	167.15	167.09	167.15	24200.0
2013-05-21 04:00:00	QQQ	ETF	74.26	74.26	74.26	74.26	100.0
2013-05-21 05:30:00	QQQ	ETF	74.07	74.07	74.05	74.05	3851.0
2013-05-21 06:30:00	QQQ	ETF	74.11	74.13	74.11	74.11	700.0
2013-05-21 07:00:00	QQQ	ETF	74.11	74.11	74.05	74.08	8600.0
2013-05-21 07:30:00	QQQ	ETF	74.11	74.11	74.11	74.11	2200.0
2013-05-21 08:00:00	QQQ	ETF	74.17	74.22	74.16	74.22	6825.0
2013-05-21 08:30:00	QQQ	ETF	74.2	74.22	74.17	74.22	70312.0
2013-05-21 09:00:00	QQQ	ETF	74.22	74.28	74.12	74.17	153578.0
2013-05-21 09:30:00	QQQ	ETF	74.18	74.319	74.105	74.27	2392718.0
2013-05-21 10:00:00	QQQ	ETF	74.27	74.3	73.91	73.96	2870212.0
2013-05-21 10:30:00	QQQ	ETF	73.96	74.06	73.89	74.03	1984742.0
2013-05-21 11:00:00	QQQ	ETF	74.04	74.22	74.03	74.11	2110873.0
2013-05-21 11:30:00	QQQ	ETF	74.115	74.27	74.11	74.21	1322114.0
2013-05-21 12:00:00	QQQ	ETF	74.21	74.36	74.21	74.335	1589398.0
2013-05-21 12:30:00	QQQ	ETF	74.34	74.39	74.26	74.37	1277422.0
2013-05-21 13:00:00	QQQ	ETF	74.3601	74.51	74.3601	74.43	1510549.0
2013-05-21 13:30:00	QQQ	ETF	74.429	74.44	74.36	74.41	1053107.0
2013-05-21 14:00:00	QQQ	ETF	74.41	74.54	74.39	74.39	2259157.0

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

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