PREVIEW / etf_30min / 2011-05-26

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-26.parquet
  size:    274 KB
  rows:    9,045

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-05-26 04:00:00	SPY	ETF	132.51	132.74	132.51	132.71	5732.0
2011-05-26 04:30:00	SPY	ETF	132.57	132.57	132.45	132.45	6300.0
2011-05-26 05:00:00	SPY	ETF	132.43	132.43	132.24	132.24	900.0
2011-05-26 06:00:00	SPY	ETF	132.46	132.46	132.39	132.39	1450.0
2011-05-26 06:30:00	SPY	ETF	132.5	132.55	132.38	132.41	10337.0
2011-05-26 07:00:00	SPY	ETF	132.34	132.44	132.27	132.35	99057.0
2011-05-26 07:30:00	SPY	ETF	132.35	132.51	132.33	132.5	165155.0
2011-05-26 08:00:00	SPY	ETF	132.5	132.7	132.22	132.65	854164.0
2011-05-26 08:30:00	SPY	ETF	132.63	132.63	131.96	132.22	2457365.0
2011-05-26 09:00:00	SPY	ETF	132.2	132.21	131.959	132.02	1273765.0
2011-05-26 09:30:00	SPY	ETF	132.03	132.43	131.85	131.9208	17298152.0
2011-05-26 10:00:00	SPY	ETF	131.92	132.2	131.78	132.08	14877222.0
2011-05-26 10:30:00	SPY	ETF	132.085	132.27	131.8	131.87	10246186.0
2011-05-26 11:00:00	SPY	ETF	131.87	132.19	131.78	132.18	8389053.0
2011-05-26 11:30:00	SPY	ETF	132.18	132.3	132.02	132.22	10534442.0
2011-05-26 12:00:00	SPY	ETF	132.23	132.42	132.15	132.4	8358519.0
2011-05-26 12:30:00	SPY	ETF	132.4038	132.74	132.32	132.67	9838614.0
2011-05-26 13:00:00	SPY	ETF	132.67	132.975	132.645	132.89	9189609.0
2011-05-26 13:30:00	SPY	ETF	132.89	132.93	132.73	132.79	7907580.0
2011-05-26 14:00:00	SPY	ETF	132.79	133.09	132.79	133.07	6236160.0
2011-05-26 14:30:00	SPY	ETF	133.06	133.24	133.03	133.15	12490562.0
2011-05-26 15:00:00	SPY	ETF	133.145	133.16	132.86	133.13	8221181.0
2011-05-26 15:30:00	SPY	ETF	133.13	133.21	132.84	132.99	23952727.0
2011-05-26 16:00:00	SPY	ETF	132.99	133.21	132.11	133.13	8365740.0
2011-05-26 16:30:00	SPY	ETF	133.14	133.22	132.9332	133.2	2701417.0
2011-05-26 17:00:00	SPY	ETF	133.2	133.22	133.16	133.21	61016.0
2011-05-26 17:30:00	SPY	ETF	133.21	133.27	133.18	133.2	42164.0
2011-05-26 18:00:00	SPY	ETF	133.2	133.2	133.01	133.19	9165.0
2011-05-26 18:30:00	SPY	ETF	133.16	133.2	133.15	133.18	11958.0
2011-05-26 19:00:00	SPY	ETF	133.18	133.24	133.17	133.21	44104.0
2011-05-26 19:30:00	SPY	ETF	133.23	133.25	133.19	133.22	24849.0
2011-05-26 04:30:00	QQQ	ETF	56.85	56.85	56.85	56.85	1000.0
2011-05-26 05:00:00	QQQ	ETF	56.82	56.82	56.82	56.82	1000.0
2011-05-26 06:30:00	QQQ	ETF	56.82	56.82	56.8	56.8	800.0
2011-05-26 07:00:00	QQQ	ETF	56.77	56.78	56.74	56.77	5600.0
2011-05-26 07:30:00	QQQ	ETF	56.78	56.78	56.78	56.78	100.0
2011-05-26 08:00:00	QQQ	ETF	56.86	56.91	56.84	56.91	142787.0
2011-05-26 08:30:00	QQQ	ETF	56.86	56.92	56.62	56.71	400314.0
2011-05-26 09:00:00	QQQ	ETF	56.71	56.72	56.61	56.62	442670.0
2011-05-26 09:30:00	QQQ	ETF	56.62	56.91	56.61	56.7	5890298.0
2011-05-26 10:00:00	QQQ	ETF	56.71	56.92	56.68	56.86	3660947.0
2011-05-26 10:30:00	QQQ	ETF	56.8692	56.94	56.7	56.75	1925049.0
2011-05-26 11:00:00	QQQ	ETF	56.74	56.905	56.73	56.9001	1832462.0
2011-05-26 11:30:00	QQQ	ETF	56.91	56.99	56.86	56.95	2012859.0
2011-05-26 12:00:00	QQQ	ETF	56.96	57.03	56.91	57.02	1821022.0
2011-05-26 12:30:00	QQQ	ETF	57.0208	57.16	56.99	57.12	2914729.0
2011-05-26 13:00:00	QQQ	ETF	57.12	57.21	57.07	57.1815	1757503.0
2011-05-26 13:30:00	QQQ	ETF	57.1817	57.19	57.1	57.129	2171169.0
2011-05-26 14:00:00	QQQ	ETF	57.1281	57.26	57.125	57.25	1112401.0
2011-05-26 14:30:00	QQQ	ETF	57.25	57.3	57.22	57.28	2585177.0

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

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