PREVIEW / etf_30min / 2011-12-08

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-08.parquet
  size:    288 KB
  rows:    9,475

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-12-08 04:00:00	SPY	ETF	126.76	126.77	126.56	126.56	34800.0
2011-12-08 04:30:00	SPY	ETF	126.65	126.72	126.5	126.67	15300.0
2011-12-08 05:00:00	SPY	ETF	126.79	126.85	126.66	126.7	950.0
2011-12-08 05:30:00	SPY	ETF	126.72	126.79	126.4	126.4	97750.0
2011-12-08 06:00:00	SPY	ETF	126.39	126.56	126.39	126.56	9500.0
2011-12-08 06:30:00	SPY	ETF	126.52	126.83	126.52	126.8	71085.0
2011-12-08 07:00:00	SPY	ETF	126.73	126.82	126.66	126.81	88898.0
2011-12-08 07:30:00	SPY	ETF	126.83	127.06	126.6	126.91	836431.0
2011-12-08 08:00:00	SPY	ETF	126.91	127.05	126.56	126.91	962311.0
2011-12-08 08:30:00	SPY	ETF	126.92	127.77	126.19	126.46	9921910.0
2011-12-08 09:00:00	SPY	ETF	126.46	126.47	125.53	125.9	10739845.0
2011-12-08 09:30:00	SPY	ETF	125.9	126.18	125.63	125.79	21820918.0
2011-12-08 10:00:00	SPY	ETF	125.78	125.91	125.21	125.3	18273527.0
2011-12-08 10:30:00	SPY	ETF	125.3	125.83	125.28	125.4	13627452.0
2011-12-08 11:00:00	SPY	ETF	125.4	125.42	124.9	124.98	15972631.0
2011-12-08 11:30:00	SPY	ETF	124.98	125.15	124.65	125.06	12192705.0
2011-12-08 12:00:00	SPY	ETF	125.06	125.25	124.83	124.9928	11696561.0
2011-12-08 12:30:00	SPY	ETF	125.0	125.03	124.75	124.86	9270037.0
2011-12-08 13:00:00	SPY	ETF	124.86	124.87	124.26	124.51	14336502.0
2011-12-08 13:30:00	SPY	ETF	124.51	124.67	124.35	124.63	7212108.0
2011-12-08 14:00:00	SPY	ETF	124.63	124.795	124.31	124.59	7008661.0
2011-12-08 14:30:00	SPY	ETF	124.59	124.7	124.134	124.27	9511931.0
2011-12-08 15:00:00	SPY	ETF	124.27	124.93	124.18	124.78	15300019.0
2011-12-08 15:30:00	SPY	ETF	124.77	125.21	123.65	123.97	45705957.0
2011-12-08 16:00:00	SPY	ETF	123.97	124.26	123.92	124.13	9238120.0
2011-12-08 16:30:00	SPY	ETF	124.13	126.6207	123.82	123.84	2265448.0
2011-12-08 17:00:00	SPY	ETF	123.83	123.91	123.76	123.76	175600.0
2011-12-08 17:30:00	SPY	ETF	123.78	123.98	123.78	123.95	212469.0
2011-12-08 18:00:00	SPY	ETF	123.94	124.06	123.92	124.05	411171.0
2011-12-08 18:30:00	SPY	ETF	124.06	124.16	124.03	124.12	124000.0
2011-12-08 19:00:00	SPY	ETF	124.05	124.32	124.05	124.21	108087.0
2011-12-08 19:30:00	SPY	ETF	124.24	124.27	124.08	124.11	93064.0
2011-12-08 04:00:00	QQQ	ETF	57.15	57.15	57.15	57.15	500.0
2011-12-08 05:30:00	QQQ	ETF	57.03	57.03	56.97	56.97	700.0
2011-12-08 07:00:00	QQQ	ETF	57.06	57.11	57.03	57.07	46920.0
2011-12-08 07:30:00	QQQ	ETF	57.12	57.28	57.07	57.26	349989.0
2011-12-08 08:00:00	QQQ	ETF	57.21	57.25	57.08	57.2	509572.0
2011-12-08 08:30:00	QQQ	ETF	57.22	57.55	56.87	56.96	2007564.0
2011-12-08 09:00:00	QQQ	ETF	56.94	56.94	56.56	56.75	804540.0
2011-12-08 09:30:00	QQQ	ETF	56.74	57.15	56.64	56.95	4516077.0
2011-12-08 10:00:00	QQQ	ETF	56.95	57.02	56.64	56.68	3888389.0
2011-12-08 10:30:00	QQQ	ETF	56.68	57.0	56.67	56.8	3543756.0
2011-12-08 11:00:00	QQQ	ETF	56.79	56.82	56.6	56.67	2238557.0
2011-12-08 11:30:00	QQQ	ETF	56.68	56.76	56.57	56.72	2255159.0
2011-12-08 12:00:00	QQQ	ETF	56.72	56.78	56.59	56.66	4196928.0
2011-12-08 12:30:00	QQQ	ETF	56.66	56.69	56.56	56.6	1689391.0
2011-12-08 13:00:00	QQQ	ETF	56.6	56.6	56.3	56.4	3341807.0
2011-12-08 13:30:00	QQQ	ETF	56.395	56.5	56.32	56.48	2552888.0
2011-12-08 14:00:00	QQQ	ETF	56.48	56.56	56.37	56.45	1582791.0
2011-12-08 14:30:00	QQQ	ETF	56.44	56.49	56.28	56.34	2613046.0

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

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