PREVIEW / etf_30min / 2012-08-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-14.parquet
  size:    273 KB
  rows:    9,181

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
2012-08-14 04:00:00	SPY	ETF	141.3	141.33	141.3	141.3	10400.0
2012-08-14 04:30:00	SPY	ETF	141.3	141.3	141.18	141.18	3350.0
2012-08-14 05:00:00	SPY	ETF	141.22	141.28	141.22	141.28	2910.0
2012-08-14 05:30:00	SPY	ETF	141.23	141.23	141.16	141.16	1200.0
2012-08-14 06:00:00	SPY	ETF	141.16	141.22	141.16	141.22	1210.0
2012-08-14 06:30:00	SPY	ETF	141.23	141.23	141.22	141.22	300.0
2012-08-14 07:00:00	SPY	ETF	141.12	141.15	141.0	141.06	43720.0
2012-08-14 07:30:00	SPY	ETF	141.06	141.17	141.04	141.17	70180.0
2012-08-14 08:00:00	SPY	ETF	141.16	141.28	141.11	141.22	256844.0
2012-08-14 08:30:00	SPY	ETF	141.22	141.57	141.12	141.32	1864127.0
2012-08-14 09:00:00	SPY	ETF	141.31	141.42	141.25	141.3	916588.0
2012-08-14 09:30:00	SPY	ETF	141.29	141.38	140.85	141.0	12218864.0
2012-08-14 10:00:00	SPY	ETF	141.005	141.2	140.89	140.988	10809718.0
2012-08-14 10:30:00	SPY	ETF	140.985	141.13	140.82	141.07	7546951.0
2012-08-14 11:00:00	SPY	ETF	141.07	141.17	141.04	141.15	4998972.0
2012-08-14 11:30:00	SPY	ETF	141.15	141.31	141.15	141.2	4069933.0
2012-08-14 12:00:00	SPY	ETF	141.21	141.26	141.1	141.19	5577347.0
2012-08-14 12:30:00	SPY	ETF	141.18	141.27	140.9	140.99	5931543.0
2012-08-14 13:00:00	SPY	ETF	141.0	141.07	140.84	140.9	4051366.0
2012-08-14 13:30:00	SPY	ETF	140.9	141.02	140.89	140.98	3519085.0
2012-08-14 14:00:00	SPY	ETF	140.975	141.05	140.87	140.949	3975613.0
2012-08-14 14:30:00	SPY	ETF	140.96	141.07	140.88	141.06	3436788.0
2012-08-14 15:00:00	SPY	ETF	141.05	141.07	140.77	140.86	6706287.0
2012-08-14 15:30:00	SPY	ETF	140.86	140.86	140.37	140.76	13394601.0
2012-08-14 16:00:00	SPY	ETF	140.77	140.9412	140.6613	140.76	12078829.0
2012-08-14 16:30:00	SPY	ETF	140.75	140.75	140.6	140.68	313418.0
2012-08-14 17:00:00	SPY	ETF	140.71	140.71	140.64	140.67	25200.0
2012-08-14 17:30:00	SPY	ETF	140.66	140.7	140.66	140.68	15413.0
2012-08-14 18:00:00	SPY	ETF	140.68	140.7	140.65	140.65	56950.0
2012-08-14 18:30:00	SPY	ETF	140.66	140.67	140.63	140.64	12730.0
2012-08-14 19:00:00	SPY	ETF	140.63	140.64	140.57	140.63	17675.0
2012-08-14 19:30:00	SPY	ETF	140.61	140.66	140.61	140.66	82305.0
2012-08-14 05:30:00	QQQ	ETF	67.17	67.17	67.17	67.17	3000.0
2012-08-14 06:00:00	QQQ	ETF	67.2	67.2	67.15	67.15	300.0
2012-08-14 07:00:00	QQQ	ETF	67.1	67.15	67.1	67.1	45585.0
2012-08-14 07:30:00	QQQ	ETF	67.18	67.18	67.15	67.15	1400.0
2012-08-14 08:00:00	QQQ	ETF	67.16	67.21	67.1	67.19	78410.0
2012-08-14 08:30:00	QQQ	ETF	67.23	67.58	67.13	67.31	197694.0
2012-08-14 09:00:00	QQQ	ETF	67.32	67.36	67.25	67.29	122540.0
2012-08-14 09:30:00	QQQ	ETF	67.28	67.34	67.13	67.2501	3905282.0
2012-08-14 10:00:00	QQQ	ETF	67.25	67.31	67.13	67.2	1949897.0
2012-08-14 10:30:00	QQQ	ETF	67.21	67.33	67.11	67.32	1745989.0
2012-08-14 11:00:00	QQQ	ETF	67.32	67.39	67.29	67.37	1640415.0
2012-08-14 11:30:00	QQQ	ETF	67.37	67.41	67.2999	67.3199	821797.0
2012-08-14 12:00:00	QQQ	ETF	67.313	67.35	67.24	67.28	697652.0
2012-08-14 12:30:00	QQQ	ETF	67.28	67.31	67.06	67.1455	1184628.0
2012-08-14 13:00:00	QQQ	ETF	67.15	67.21	67.08	67.13	747420.0
2012-08-14 13:30:00	QQQ	ETF	67.13	67.24	67.13	67.19	635874.0
2012-08-14 14:00:00	QQQ	ETF	67.1992	67.22	67.088	67.16	828576.0
2012-08-14 14:30:00	QQQ	ETF	67.17	67.218	67.11	67.21	635279.0

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

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