PREVIEW / etf_30min / 2013-04-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-15.parquet
  size:    344 KB
  rows:    11,356

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-04-15 04:00:00	SPY	ETF	158.25	158.25	157.62	157.89	23350.0
2013-04-15 04:30:00	SPY	ETF	157.8	157.8	157.77	157.79	7800.0
2013-04-15 05:00:00	SPY	ETF	157.93	158.09	157.93	158.01	8390.0
2013-04-15 05:30:00	SPY	ETF	157.98	157.99	157.65	157.72	51699.0
2013-04-15 06:00:00	SPY	ETF	157.73	157.78	157.61	157.71	118300.0
2013-04-15 06:30:00	SPY	ETF	157.75	157.91	157.75	157.76	66909.0
2013-04-15 07:00:00	SPY	ETF	157.73	157.86	157.66	157.86	123870.0
2013-04-15 07:30:00	SPY	ETF	157.86	157.93	157.83	157.92	129862.0
2013-04-15 08:00:00	SPY	ETF	157.94	158.37	157.69	158.17	512383.0
2013-04-15 08:30:00	SPY	ETF	158.18	158.18	157.91	158.02	992280.0
2013-04-15 09:00:00	SPY	ETF	158.02	158.15	157.86	158.01	954025.0
2013-04-15 09:30:00	SPY	ETF	158.0	158.13	157.6	158.01	14183419.0
2013-04-15 10:00:00	SPY	ETF	158.01	158.02	157.46	157.75	12757282.0
2013-04-15 10:30:00	SPY	ETF	157.74	158.03	157.62	157.93	11368794.0
2013-04-15 11:00:00	SPY	ETF	157.93	157.93	157.54	157.6593	8044394.0
2013-04-15 11:30:00	SPY	ETF	157.65	157.915	157.11	157.18	10123513.0
2013-04-15 12:00:00	SPY	ETF	157.18	157.29	156.98	157.09	9401390.0
2013-04-15 12:30:00	SPY	ETF	157.1	157.1	156.33	156.609	11992268.0
2013-04-15 13:00:00	SPY	ETF	156.6	156.76	156.48	156.68	8898894.0
2013-04-15 13:30:00	SPY	ETF	156.68	156.71	156.46	156.5	5364807.0
2013-04-15 14:00:00	SPY	ETF	156.5	156.51	156.04	156.19	11489774.0
2013-04-15 14:30:00	SPY	ETF	156.1901	156.77	155.95	156.03	14991721.0
2013-04-15 15:00:00	SPY	ETF	156.03	156.28	155.66	155.84	29995571.0
2013-04-15 15:30:00	SPY	ETF	155.84	155.91	155.1	155.1	42595372.0
2013-04-15 16:00:00	SPY	ETF	155.14	158.8294	154.72	154.76	11195413.0
2013-04-15 16:30:00	SPY	ETF	154.72	158.8294	154.32	154.65	5683252.0
2013-04-15 17:00:00	SPY	ETF	154.65	154.84	154.54	154.84	526869.0
2013-04-15 17:30:00	SPY	ETF	154.83	154.86	154.7	154.7	312979.0
2013-04-15 18:00:00	SPY	ETF	154.7	155.09	154.7	155.09	489484.0
2013-04-15 18:30:00	SPY	ETF	155.06	155.08	154.96	155.04	108624.0
2013-04-15 19:00:00	SPY	ETF	155.07	155.22	155.07	155.22	368925.0
2013-04-15 19:30:00	SPY	ETF	155.22	155.27	155.21	155.24	81600.0
2013-04-15 04:00:00	QQQ	ETF	69.54	69.54	69.54	69.54	200.0
2013-04-15 05:30:00	QQQ	ETF	69.5	69.5	69.5	69.5	100.0
2013-04-15 06:00:00	QQQ	ETF	69.5	69.56	69.5	69.54	3300.0
2013-04-15 06:30:00	QQQ	ETF	69.59	69.59	69.54	69.54	1200.0
2013-04-15 07:00:00	QQQ	ETF	69.5	69.53	69.5	69.52	22040.0
2013-04-15 07:30:00	QQQ	ETF	69.56	69.58	69.54	69.58	22180.0
2013-04-15 08:00:00	QQQ	ETF	69.58	69.69	69.47	69.68	65541.0
2013-04-15 08:30:00	QQQ	ETF	69.62	69.67	69.57	69.64	68903.0
2013-04-15 09:00:00	QQQ	ETF	69.64	69.69	69.58	69.67	169296.0
2013-04-15 09:30:00	QQQ	ETF	69.68	69.79	69.5	69.66	4756897.0
2013-04-15 10:00:00	QQQ	ETF	69.66	69.66	69.39	69.556	2459208.0
2013-04-15 10:30:00	QQQ	ETF	69.56	69.75	69.48	69.68	3540412.0
2013-04-15 11:00:00	QQQ	ETF	69.68	69.68	69.46	69.56	2322764.0
2013-04-15 11:30:00	QQQ	ETF	69.552	69.7	69.26	69.3	2743300.0
2013-04-15 12:00:00	QQQ	ETF	69.31	69.37	69.18	69.25	2809083.0
2013-04-15 12:30:00	QQQ	ETF	69.24	69.241	68.91	69.05	2696948.0
2013-04-15 13:00:00	QQQ	ETF	69.0599	69.15	69.0	69.14	1372253.0
2013-04-15 13:30:00	QQQ	ETF	69.135	69.14	69.01	69.03	869399.0

> showing 50 of 11,356 rows — these rows as CSV

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