PREVIEW / etf_30min / 2011-06-29

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-29.parquet
  size:    282 KB
  rows:    9,425

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-06-29 04:00:00	SPY	ETF	129.98	130.31	129.98	130.31	1400.0
2011-06-29 04:30:00	SPY	ETF	130.2	130.23	130.19	130.2	1600.0
2011-06-29 05:00:00	SPY	ETF	130.07	130.2	130.07	130.2	300.0
2011-06-29 05:30:00	SPY	ETF	130.27	130.4	130.23	130.4	11543.0
2011-06-29 06:00:00	SPY	ETF	130.25	130.27	130.16	130.19	5800.0
2011-06-29 06:30:00	SPY	ETF	130.21	130.7	130.19	130.56	214837.0
2011-06-29 07:00:00	SPY	ETF	130.63	130.88	130.59	130.75	637812.0
2011-06-29 07:30:00	SPY	ETF	130.75	130.8	130.45	130.48	561768.0
2011-06-29 08:00:00	SPY	ETF	130.49	130.8	130.47	130.58	1305820.0
2011-06-29 08:30:00	SPY	ETF	130.59	130.77	130.09	130.6	5434643.0
2011-06-29 09:00:00	SPY	ETF	130.59	130.86	130.04	130.21	13130778.0
2011-06-29 09:30:00	SPY	ETF	130.2	130.35	129.91	130.1	28711222.0
2011-06-29 10:00:00	SPY	ETF	130.1	130.19	129.71	130.11	20314181.0
2011-06-29 10:30:00	SPY	ETF	130.11	130.6	130.07	130.59	16331341.0
2011-06-29 11:00:00	SPY	ETF	130.57	130.77	130.51	130.65	13507435.0
2011-06-29 11:30:00	SPY	ETF	130.65	130.72	130.49	130.68	10035080.0
2011-06-29 12:00:00	SPY	ETF	130.69	130.84	130.63	130.67	8753452.0
2011-06-29 12:30:00	SPY	ETF	130.68	130.77	130.64	130.67	4570394.0
2011-06-29 13:00:00	SPY	ETF	130.67	130.93	130.62	130.745	8760808.0
2011-06-29 13:30:00	SPY	ETF	130.745	130.86	130.56	130.61	9472905.0
2011-06-29 14:00:00	SPY	ETF	130.62	130.69	130.19	130.32	20352282.0
2011-06-29 14:30:00	SPY	ETF	130.3201	130.47	130.16	130.445	13714968.0
2011-06-29 15:00:00	SPY	ETF	130.45	130.77	130.39	130.65	16493133.0
2011-06-29 15:30:00	SPY	ETF	130.66	130.89	130.6	130.74	30745914.0
2011-06-29 16:00:00	SPY	ETF	130.75	131.0	130.4365	130.81	14150971.0
2011-06-29 16:30:00	SPY	ETF	130.81	130.88	130.68	130.82	620493.0
2011-06-29 17:00:00	SPY	ETF	130.81	130.84	130.0	130.84	1156595.0
2011-06-29 17:30:00	SPY	ETF	130.85	130.86	129.6321	130.84	2029510.0
2011-06-29 18:00:00	SPY	ETF	130.84	130.92	130.75	130.9	278408.0
2011-06-29 18:30:00	SPY	ETF	130.89	130.91	130.84	130.88	22350.0
2011-06-29 19:00:00	SPY	ETF	130.88	130.94	130.88	130.89	21920.0
2011-06-29 19:30:00	SPY	ETF	130.89	130.93	130.87	130.9	93810.0
2011-06-29 04:00:00	QQQ	ETF	56.24	56.24	56.24	56.24	676.0
2011-06-29 05:00:00	QQQ	ETF	56.22	56.26	56.22	56.26	500.0
2011-06-29 05:30:00	QQQ	ETF	56.31	56.33	56.31	56.33	1300.0
2011-06-29 06:00:00	QQQ	ETF	56.36	56.36	56.3	56.3	800.0
2011-06-29 06:30:00	QQQ	ETF	56.3	56.45	56.3	56.45	6380.0
2011-06-29 07:00:00	QQQ	ETF	56.45	56.51	56.41	56.51	76750.0
2011-06-29 07:30:00	QQQ	ETF	56.53	56.53	56.35	56.35	76976.0
2011-06-29 08:00:00	QQQ	ETF	56.35	56.42	56.33	56.38	278843.0
2011-06-29 08:30:00	QQQ	ETF	56.39	56.43	56.17	56.36	1028362.0
2011-06-29 09:00:00	QQQ	ETF	56.38	56.45	56.09	56.23	1995027.0
2011-06-29 09:30:00	QQQ	ETF	56.23	56.23	55.93	56.05	9749455.0
2011-06-29 10:00:00	QQQ	ETF	56.05	56.1774	55.9	56.1171	5860008.0
2011-06-29 10:30:00	QQQ	ETF	56.1195	56.37	56.08	56.345	5583513.0
2011-06-29 11:00:00	QQQ	ETF	56.345	56.4	56.26	56.285	4550823.0
2011-06-29 11:30:00	QQQ	ETF	56.285	56.31	56.19	56.29	2196605.0
2011-06-29 12:00:00	QQQ	ETF	56.285	56.35	56.26	56.305	1279397.0
2011-06-29 12:30:00	QQQ	ETF	56.31	56.34	56.28	56.3	691460.0
2011-06-29 13:00:00	QQQ	ETF	56.305	56.41	56.29	56.345	1233005.0

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

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