PREVIEW / etf_30min / 2011-10-27

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-27.parquet
  size:    333 KB
  rows:    10,901

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-10-27 04:00:00	SPY	ETF	125.96	126.5	125.96	126.43	123879.0
2011-10-27 04:30:00	SPY	ETF	126.46	126.5	126.16	126.16	100650.0
2011-10-27 05:00:00	SPY	ETF	126.11	126.43	126.11	126.4	15700.0
2011-10-27 05:30:00	SPY	ETF	126.31	126.77	126.31	126.74	49590.0
2011-10-27 06:00:00	SPY	ETF	126.73	126.76	126.58	126.7	125177.0
2011-10-27 06:30:00	SPY	ETF	126.72	126.93	126.65	126.88	239670.0
2011-10-27 07:00:00	SPY	ETF	126.9	126.92	126.75	126.85	1028645.0
2011-10-27 07:30:00	SPY	ETF	126.89	127.25	126.78	127.12	1284912.0
2011-10-27 08:00:00	SPY	ETF	127.1	127.45	125.44	127.27	4864622.0
2011-10-27 08:30:00	SPY	ETF	127.26	127.51	127.13	127.33	4969855.0
2011-10-27 09:00:00	SPY	ETF	127.32	127.85	127.32	127.62	5810857.0
2011-10-27 09:30:00	SPY	ETF	127.63	127.8	127.12	127.141	40565092.0
2011-10-27 10:00:00	SPY	ETF	127.14	127.24	126.67	126.76	28896380.0
2011-10-27 10:30:00	SPY	ETF	126.76	127.21	126.61	127.135	21736142.0
2011-10-27 11:00:00	SPY	ETF	127.13	127.33	127.04	127.19	16983328.0
2011-10-27 11:30:00	SPY	ETF	127.18	127.7	127.09	127.67	15207607.0
2011-10-27 12:00:00	SPY	ETF	127.67	128.08	127.66	127.86	20096391.0
2011-10-27 12:30:00	SPY	ETF	127.86	128.06	127.75	127.79	11593549.0
2011-10-27 13:00:00	SPY	ETF	127.8	128.31	127.79	128.21	13686005.0
2011-10-27 13:30:00	SPY	ETF	128.2	128.61	128.15	128.57	14050074.0
2011-10-27 14:00:00	SPY	ETF	128.56	128.78	128.35	128.7	18276183.0
2011-10-27 14:30:00	SPY	ETF	128.7	128.93	128.57	128.68	19292420.0
2011-10-27 15:00:00	SPY	ETF	128.68	129.42	128.64	129.1	29858704.0
2011-10-27 15:30:00	SPY	ETF	129.1	129.4	127.98	128.6	55919212.0
2011-10-27 16:00:00	SPY	ETF	128.59	128.85	124.3187	128.73	16318410.0
2011-10-27 16:30:00	SPY	ETF	128.74	128.8	128.1491	128.74	7547296.0
2011-10-27 17:00:00	SPY	ETF	128.75	128.84	124.3187	128.81	9693751.0
2011-10-27 17:30:00	SPY	ETF	128.83	128.9	128.7	128.71	245259.0
2011-10-27 18:00:00	SPY	ETF	128.73	128.76	128.53	128.71	648755.0
2011-10-27 18:30:00	SPY	ETF	128.71	128.74	128.65	128.66	6488.0
2011-10-27 19:00:00	SPY	ETF	128.66	128.75	128.66	128.74	43089.0
2011-10-27 19:30:00	SPY	ETF	128.77	128.92	128.75	128.86	117945.0
2011-10-27 04:00:00	QQQ	ETF	57.88	58.19	57.88	58.19	4425.0
2011-10-27 04:30:00	QQQ	ETF	58.22	58.22	58.19	58.19	400.0
2011-10-27 05:00:00	QQQ	ETF	58.2	58.2	58.2	58.2	200.0
2011-10-27 05:30:00	QQQ	ETF	58.1	58.3	58.1	58.3	700.0
2011-10-27 06:00:00	QQQ	ETF	58.3	58.32	58.22	58.32	1700.0
2011-10-27 06:30:00	QQQ	ETF	58.28	58.35	58.28	58.34	20000.0
2011-10-27 07:00:00	QQQ	ETF	58.31	58.39	58.3	58.37	88364.0
2011-10-27 07:30:00	QQQ	ETF	58.39	58.5	58.35	58.47	157494.0
2011-10-27 08:00:00	QQQ	ETF	58.47	58.54	58.45	58.53	889243.0
2011-10-27 08:30:00	QQQ	ETF	58.55	58.55	58.37	58.45	2111894.0
2011-10-27 09:00:00	QQQ	ETF	58.46	58.68	58.45	58.63	3755501.0
2011-10-27 09:30:00	QQQ	ETF	58.62	58.725	58.42	58.42	10019786.0
2011-10-27 10:00:00	QQQ	ETF	58.42	58.45	58.16	58.2	8321481.0
2011-10-27 10:30:00	QQQ	ETF	58.21	58.32	58.03	58.28	5547809.0
2011-10-27 11:00:00	QQQ	ETF	58.28	58.39	58.16	58.22	5375347.0
2011-10-27 11:30:00	QQQ	ETF	58.22	58.52	58.15	58.49	3031774.0
2011-10-27 12:00:00	QQQ	ETF	58.496	58.69	58.496	58.57	3814364.0
2011-10-27 12:30:00	QQQ	ETF	58.57	58.66	58.5	58.52	1346157.0

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

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