PREVIEW / etf_30min / 2011-07-13

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-13.parquet
  size:    291 KB
  rows:    9,616

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-07-13 04:00:00	SPY	ETF	131.94	132.31	131.94	132.31	5200.0
2011-07-13 04:30:00	SPY	ETF	132.22	132.24	132.14	132.19	8800.0
2011-07-13 05:00:00	SPY	ETF	132.25	132.51	132.25	132.51	6900.0
2011-07-13 05:30:00	SPY	ETF	132.56	132.56	132.38	132.55	3090.0
2011-07-13 06:00:00	SPY	ETF	132.49	132.49	132.32	132.38	3600.0
2011-07-13 06:30:00	SPY	ETF	132.41	132.54	132.21	132.27	59411.0
2011-07-13 07:00:00	SPY	ETF	132.27	132.37	132.14	132.37	153280.0
2011-07-13 07:30:00	SPY	ETF	132.38	132.41	132.15	132.19	345721.0
2011-07-13 08:00:00	SPY	ETF	132.19	132.49	132.04	132.14	836708.0
2011-07-13 08:30:00	SPY	ETF	132.14	132.21	131.4	131.95	1283584.0
2011-07-13 09:00:00	SPY	ETF	131.94	132.18	131.85	132.09	1046613.0
2011-07-13 09:30:00	SPY	ETF	132.09	132.33	131.86	131.93	20059353.0
2011-07-13 10:00:00	SPY	ETF	131.93	132.88	131.9	132.73	27340717.0
2011-07-13 10:30:00	SPY	ETF	132.73	133.12	132.73	133.07	12486550.0
2011-07-13 11:00:00	SPY	ETF	133.08	133.22	132.93	133.17	10427325.0
2011-07-13 11:30:00	SPY	ETF	133.17	133.17	132.86	132.94	10514391.0
2011-07-13 12:00:00	SPY	ETF	132.94	133.12	132.83	133.075	7875024.0
2011-07-13 12:30:00	SPY	ETF	133.08	133.1	132.87	132.93	7333887.0
2011-07-13 13:00:00	SPY	ETF	132.93	132.96	132.65	132.76	7601437.0
2011-07-13 13:30:00	SPY	ETF	132.76	132.91	132.56	132.59	8918304.0
2011-07-13 14:00:00	SPY	ETF	132.6	132.72	132.23	132.355	12519590.0
2011-07-13 14:30:00	SPY	ETF	132.36	132.55	132.26	132.41	7016142.0
2011-07-13 15:00:00	SPY	ETF	132.42	132.6	131.74	131.95	19195056.0
2011-07-13 15:30:00	SPY	ETF	131.96	131.96	131.519	131.84	24542855.0
2011-07-13 16:00:00	SPY	ETF	131.86	132.4684	131.4168	131.7	12284270.0
2011-07-13 16:30:00	SPY	ETF	131.71	131.8	131.4168	131.71	1145291.0
2011-07-13 17:00:00	SPY	ETF	131.71	131.71	130.69	130.85	4209228.0
2011-07-13 17:30:00	SPY	ETF	130.9	131.13	130.85	131.08	509867.0
2011-07-13 18:00:00	SPY	ETF	131.04	131.85	130.94	131.19	1424610.0
2011-07-13 18:30:00	SPY	ETF	131.19	131.4	131.12	131.33	386712.0
2011-07-13 19:00:00	SPY	ETF	131.33	131.38	131.2	131.2	182275.0
2011-07-13 19:30:00	SPY	ETF	131.2	131.29	131.07	131.29	162155.0
2011-07-13 04:00:00	QQQ	ETF	57.69	57.95	57.69	57.95	4086.0
2011-07-13 04:30:00	QQQ	ETF	57.97	58.01	57.95	58.01	500.0
2011-07-13 05:00:00	QQQ	ETF	57.96	58.05	57.95	58.05	800.0
2011-07-13 05:30:00	QQQ	ETF	58.09	58.11	58.05	58.05	1880.0
2011-07-13 06:30:00	QQQ	ETF	57.98	57.98	57.98	57.98	600.0
2011-07-13 07:00:00	QQQ	ETF	57.95	58.0	57.93	58.0	61125.0
2011-07-13 07:30:00	QQQ	ETF	58.02	58.03	57.95	57.95	5800.0
2011-07-13 08:00:00	QQQ	ETF	57.95	57.97	57.88	57.91	224373.0
2011-07-13 08:30:00	QQQ	ETF	57.92	57.95	57.86	57.88	188322.0
2011-07-13 09:00:00	QQQ	ETF	57.87	57.97	57.83	57.92	366841.0
2011-07-13 09:30:00	QQQ	ETF	57.93	58.05	57.74	57.78	9347897.0
2011-07-13 10:00:00	QQQ	ETF	57.785	58.2	57.78	58.131	11515297.0
2011-07-13 10:30:00	QQQ	ETF	58.14	58.34	58.14	58.31	3340652.0
2011-07-13 11:00:00	QQQ	ETF	58.31	58.34	58.22	58.31	4434498.0
2011-07-13 11:30:00	QQQ	ETF	58.3	58.3085	58.2	58.25	2591546.0
2011-07-13 12:00:00	QQQ	ETF	58.25	58.3	58.17	58.2799	3762729.0
2011-07-13 12:30:00	QQQ	ETF	58.2714	58.29	58.175	58.2	2697132.0
2011-07-13 13:00:00	QQQ	ETF	58.2	58.22	58.11	58.16	1581457.0

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

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