PREVIEW / etf_30min / 2012-11-15

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-15.parquet
  size:    307 KB
  rows:    10,237

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-11-15 04:00:00	SPY	ETF	136.38	136.4	136.25	136.25	10958.0
2012-11-15 04:30:00	SPY	ETF	136.2	136.39	136.2	136.38	1750.0
2012-11-15 05:00:00	SPY	ETF	136.37	136.41	136.28	136.38	7540.0
2012-11-15 05:30:00	SPY	ETF	136.44	136.54	136.39	136.52	19820.0
2012-11-15 06:00:00	SPY	ETF	136.41	136.43	136.35	136.38	7230.0
2012-11-15 06:30:00	SPY	ETF	136.38	136.43	136.3	136.32	35544.0
2012-11-15 07:00:00	SPY	ETF	136.26	136.26	135.9	135.9	663147.0
2012-11-15 07:30:00	SPY	ETF	135.9	136.11	135.88	136.1	177535.0
2012-11-15 08:00:00	SPY	ETF	136.1	136.25	135.9	136.04	370983.0
2012-11-15 08:30:00	SPY	ETF	136.2	136.29	135.61	135.83	2114349.0
2012-11-15 09:00:00	SPY	ETF	135.82	136.18	135.81	135.98	1074041.0
2012-11-15 09:30:00	SPY	ETF	135.98	136.4901	135.69	135.83	18362620.0
2012-11-15 10:00:00	SPY	ETF	135.83	136.42	135.52	136.04	17873626.0
2012-11-15 10:30:00	SPY	ETF	136.03	136.24	135.7	135.72	8812296.0
2012-11-15 11:00:00	SPY	ETF	135.715	135.86	135.44	135.54	10887796.0
2012-11-15 11:30:00	SPY	ETF	135.545	135.74	135.19	135.349	12701936.0
2012-11-15 12:00:00	SPY	ETF	135.345	135.46	135.18	135.292	8744883.0
2012-11-15 12:30:00	SPY	ETF	135.3	135.63	135.225	135.415	10029586.0
2012-11-15 13:00:00	SPY	ETF	135.41	135.84	135.28	135.83	7853474.0
2012-11-15 13:30:00	SPY	ETF	135.83	136.29	135.75	136.05	11401354.0
2012-11-15 14:00:00	SPY	ETF	136.045	136.05	135.65	135.82	8603443.0
2012-11-15 14:30:00	SPY	ETF	135.82	135.87	135.59	135.73	6827981.0
2012-11-15 15:00:00	SPY	ETF	135.72	135.725	135.24	135.33	12634175.0
2012-11-15 15:30:00	SPY	ETF	135.34	135.97	135.21	135.67	26571186.0
2012-11-15 16:00:00	SPY	ETF	135.69	136.108	135.58	135.78	8016647.0
2012-11-15 16:30:00	SPY	ETF	135.79	135.85	135.4184	135.84	950129.0
2012-11-15 17:00:00	SPY	ETF	135.86	135.87	135.71	135.73	170750.0
2012-11-15 17:30:00	SPY	ETF	135.72	135.75	135.72	135.72	35372.0
2012-11-15 18:00:00	SPY	ETF	135.72	135.81	135.72	135.75	38785.0
2012-11-15 18:30:00	SPY	ETF	135.72	135.75	135.66	135.66	27106.0
2012-11-15 19:00:00	SPY	ETF	135.68	135.68	135.49	135.51	56652.0
2012-11-15 19:30:00	SPY	ETF	135.55	135.58	135.45	135.49	65430.0
2012-11-15 04:00:00	QQQ	ETF	62.3	62.3	62.3	62.3	100.0
2012-11-15 04:30:00	QQQ	ETF	62.36	62.36	62.36	62.36	100.0
2012-11-15 05:00:00	QQQ	ETF	62.38	62.38	62.38	62.38	200.0
2012-11-15 05:30:00	QQQ	ETF	62.4	62.44	62.4	62.44	400.0
2012-11-15 06:30:00	QQQ	ETF	62.38	62.38	62.33	62.33	16300.0
2012-11-15 07:00:00	QQQ	ETF	62.34	62.34	62.23	62.23	11450.0
2012-11-15 07:30:00	QQQ	ETF	62.19	62.32	62.19	62.32	7108.0
2012-11-15 08:00:00	QQQ	ETF	62.2	62.48	62.2	62.35	78079.0
2012-11-15 08:30:00	QQQ	ETF	62.29	62.31	62.18	62.3	232720.0
2012-11-15 09:00:00	QQQ	ETF	62.32	62.41	62.29	62.3	170357.0
2012-11-15 09:30:00	QQQ	ETF	62.29	62.49	62.1	62.14	4940489.0
2012-11-15 10:00:00	QQQ	ETF	62.14	62.48	62.03	62.2301	3898957.0
2012-11-15 10:30:00	QQQ	ETF	62.23	62.3	62.02	62.0401	2234061.0
2012-11-15 11:00:00	QQQ	ETF	62.05	62.11	61.9	61.99	2621384.0
2012-11-15 11:30:00	QQQ	ETF	61.9928	62.0999	61.85	61.93	3730736.0
2012-11-15 12:00:00	QQQ	ETF	61.934	62.0	61.88	61.94	1753898.0
2012-11-15 12:30:00	QQQ	ETF	61.94	62.12	61.93	61.9999	1286914.0
2012-11-15 13:00:00	QQQ	ETF	61.99	62.16	61.93	62.16	2430837.0

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

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