PREVIEW / etf_30min / 2013-11-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-12.parquet
  size:    316 KB
  rows:    10,697

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-11-12 04:00:00	SPY	ETF	177.12	177.12	176.82	176.83	44869.0
2013-11-12 04:30:00	SPY	ETF	176.85	176.92	176.81	176.91	2420.0
2013-11-12 05:00:00	SPY	ETF	176.89	176.97	176.89	176.96	8000.0
2013-11-12 05:30:00	SPY	ETF	176.95	176.97	176.91	176.94	4500.0
2013-11-12 06:00:00	SPY	ETF	176.94	177.02	176.87	177.02	25500.0
2013-11-12 06:30:00	SPY	ETF	176.98	176.98	176.85	176.93	99900.0
2013-11-12 07:00:00	SPY	ETF	176.94	177.04	176.92	176.99	44330.0
2013-11-12 07:30:00	SPY	ETF	176.97	177.09	176.94	176.94	50645.0
2013-11-12 08:00:00	SPY	ETF	176.99	177.29	176.75	176.83	472634.0
2013-11-12 08:30:00	SPY	ETF	176.83	176.93	176.81	176.83	276088.0
2013-11-12 09:00:00	SPY	ETF	176.83	176.97	176.81	176.93	300101.0
2013-11-12 09:30:00	SPY	ETF	176.94	177.22	176.74	177.14	7874364.0
2013-11-12 10:00:00	SPY	ETF	177.14	177.36	176.86	177.26	7731797.0
2013-11-12 10:30:00	SPY	ETF	177.269	177.33	176.97	177.0	4927513.0
2013-11-12 11:00:00	SPY	ETF	177.01	177.13	176.9	177.09	4898861.0
2013-11-12 11:30:00	SPY	ETF	177.08	177.21	176.68	176.83	6257838.0
2013-11-12 12:00:00	SPY	ETF	176.83	176.9	176.52	176.66	6011120.0
2013-11-12 12:30:00	SPY	ETF	176.66	176.8	176.54	176.73	3930693.0
2013-11-12 13:00:00	SPY	ETF	176.72	176.85	176.64	176.649	2874895.0
2013-11-12 13:30:00	SPY	ETF	176.65	176.69	176.37	176.52	5002437.0
2013-11-12 14:00:00	SPY	ETF	176.52	176.7	176.47	176.48	2901915.0
2013-11-12 14:30:00	SPY	ETF	176.47	176.99	176.47	176.95	5395291.0
2013-11-12 15:00:00	SPY	ETF	176.95	177.09	176.79	176.82	5767941.0
2013-11-12 15:30:00	SPY	ETF	176.825	177.02	176.74	176.98	10775648.0
2013-11-12 16:00:00	SPY	ETF	176.98	177.06	176.68	177.05	6444705.0
2013-11-12 16:30:00	SPY	ETF	177.05	177.07	176.6164	177.05	502758.0
2013-11-12 17:00:00	SPY	ETF	177.06	177.06	176.97	176.97	45210.0
2013-11-12 17:30:00	SPY	ETF	176.98	177.03	176.98	177.02	18620.0
2013-11-12 18:00:00	SPY	ETF	177.0	177.03	176.96	177.01	55710.0
2013-11-12 18:30:00	SPY	ETF	177.04	177.04	177.0	177.0	2900.0
2013-11-12 19:00:00	SPY	ETF	177.02	177.09	176.99	177.07	74552.0
2013-11-12 19:30:00	SPY	ETF	177.08	177.11	177.07	177.1	49460.0
2013-11-12 04:00:00	QQQ	ETF	82.19	82.19	82.13	82.14	16800.0
2013-11-12 04:30:00	QQQ	ETF	82.15	82.15	82.13	82.13	3200.0
2013-11-12 05:00:00	QQQ	ETF	82.15	82.15	82.15	82.15	1600.0
2013-11-12 05:30:00	QQQ	ETF	82.18	82.18	82.16	82.17	9300.0
2013-11-12 06:00:00	QQQ	ETF	82.18	82.24	82.18	82.24	4900.0
2013-11-12 06:30:00	QQQ	ETF	82.22	82.22	82.18	82.22	8600.0
2013-11-12 07:00:00	QQQ	ETF	82.19	82.24	82.18	82.24	6300.0
2013-11-12 07:30:00	QQQ	ETF	82.25	82.27	82.22	82.22	5500.0
2013-11-12 08:00:00	QQQ	ETF	82.21	82.24	82.11	82.12	26309.0
2013-11-12 08:30:00	QQQ	ETF	82.12	82.17	82.1	82.13	61200.0
2013-11-12 09:00:00	QQQ	ETF	82.12	82.21	82.12	82.16	97351.0
2013-11-12 09:30:00	QQQ	ETF	82.16	82.52	82.1199	82.45	2606957.0
2013-11-12 10:00:00	QQQ	ETF	82.46	82.62	82.27	82.59	2164041.0
2013-11-12 10:30:00	QQQ	ETF	82.59	82.66	82.46	82.4899	1412194.0
2013-11-12 11:00:00	QQQ	ETF	82.49	82.51	82.39	82.47	1255450.0
2013-11-12 11:30:00	QQQ	ETF	82.48	82.56	82.25	82.3605	1676737.0
2013-11-12 12:00:00	QQQ	ETF	82.37	82.4	82.19	82.3201	942724.0
2013-11-12 12:30:00	QQQ	ETF	82.32	82.42	82.28	82.365	748542.0

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

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