PREVIEW / etf_30min / 2011-06-24

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-24.parquet
  size:    270 KB
  rows:    9,043

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-24 04:00:00	SPY	ETF	128.55	128.76	128.55	128.76	1000.0
2011-06-24 04:30:00	SPY	ETF	128.78	129.01	128.78	128.95	4270.0
2011-06-24 05:00:00	SPY	ETF	128.95	129.01	128.9	129.0	2990.0
2011-06-24 05:30:00	SPY	ETF	128.96	128.96	128.77	128.77	1600.0
2011-06-24 06:00:00	SPY	ETF	128.72	128.72	128.14	128.6	37900.0
2011-06-24 06:30:00	SPY	ETF	128.58	128.59	127.95	128.16	170470.0
2011-06-24 07:00:00	SPY	ETF	128.19	128.44	128.13	128.22	338385.0
2011-06-24 07:30:00	SPY	ETF	128.2	128.28	128.09	128.11	339460.0
2011-06-24 08:00:00	SPY	ETF	128.1	128.34	127.89	128.22	999964.0
2011-06-24 08:30:00	SPY	ETF	128.22	128.64	128.22	128.5	2403692.0
2011-06-24 09:00:00	SPY	ETF	128.5	128.6	128.26	128.27	1019800.0
2011-06-24 09:30:00	SPY	ETF	128.27	128.37	127.69	127.88	21159410.0
2011-06-24 10:00:00	SPY	ETF	127.87	127.97	127.05	127.215	21856684.0
2011-06-24 10:30:00	SPY	ETF	127.22	127.49	126.94	127.17	16283945.0
2011-06-24 11:00:00	SPY	ETF	127.17	127.32	126.92	127.29	17846702.0
2011-06-24 11:30:00	SPY	ETF	127.29	127.48	127.18	127.3	9837601.0
2011-06-24 12:00:00	SPY	ETF	127.295	127.44	127.1	127.2	6886192.0
2011-06-24 12:30:00	SPY	ETF	127.19	127.35	126.83	126.99	9391732.0
2011-06-24 13:00:00	SPY	ETF	126.99	127.16	126.76	127.09	9636672.0
2011-06-24 13:30:00	SPY	ETF	127.1	128.2717	126.97	127.21	10967892.0
2011-06-24 14:00:00	SPY	ETF	127.21	128.2716	126.89	127.09	10578117.0
2011-06-24 14:30:00	SPY	ETF	127.09	127.2	126.89	126.96	9848262.0
2011-06-24 15:00:00	SPY	ETF	126.97	126.99	126.73	126.79	16002907.0
2011-06-24 15:30:00	SPY	ETF	126.79	127.03	126.62	126.8	35970393.0
2011-06-24 16:00:00	SPY	ETF	126.81	128.2716	126.62	126.78	15132450.0
2011-06-24 16:30:00	SPY	ETF	126.78	126.8792	126.64	126.67	6123262.0
2011-06-24 17:00:00	SPY	ETF	126.67	128.2716	126.65	126.72	682177.0
2011-06-24 17:30:00	SPY	ETF	126.74	126.82	126.72	126.77	39488.0
2011-06-24 18:00:00	SPY	ETF	126.74	126.81	126.7	126.8	285742.0
2011-06-24 18:30:00	SPY	ETF	126.8	126.8	126.72	126.72	9251.0
2011-06-24 19:00:00	SPY	ETF	126.77	126.78	126.72	126.75	2981.0
2011-06-24 19:30:00	SPY	ETF	126.76	126.77	126.7	126.71	20539.0
2011-06-24 04:00:00	QQQ	ETF	55.25	55.31	55.25	55.31	2400.0
2011-06-24 04:30:00	QQQ	ETF	55.45	55.47	55.39	55.39	10200.0
2011-06-24 05:30:00	QQQ	ETF	55.44	55.44	55.44	55.44	400.0
2011-06-24 06:00:00	QQQ	ETF	55.17	55.17	55.17	55.17	100.0
2011-06-24 06:30:00	QQQ	ETF	55.19	55.27	55.13	55.14	1800.0
2011-06-24 07:00:00	QQQ	ETF	55.2	55.2	55.12	55.12	59460.0
2011-06-24 07:30:00	QQQ	ETF	55.12	55.15	55.09	55.1	165398.0
2011-06-24 08:00:00	QQQ	ETF	55.07	55.16	55.04	55.16	734385.0
2011-06-24 08:30:00	QQQ	ETF	55.13	55.26	55.13	55.22	672661.0
2011-06-24 09:00:00	QQQ	ETF	55.22	55.25	55.06	55.06	301430.0
2011-06-24 09:30:00	QQQ	ETF	55.06	55.13	54.83	54.96	5830292.0
2011-06-24 10:00:00	QQQ	ETF	54.96	55.01	54.6	54.72	7220793.0
2011-06-24 10:30:00	QQQ	ETF	54.72	54.83	54.58	54.69	3983555.0
2011-06-24 11:00:00	QQQ	ETF	54.69	54.77	54.57	54.7614	3395750.0
2011-06-24 11:30:00	QQQ	ETF	54.77	54.8	54.66	54.68	2657707.0
2011-06-24 12:00:00	QQQ	ETF	54.68	54.75	54.61	54.65	2277879.0
2011-06-24 12:30:00	QQQ	ETF	54.65	54.71	54.44	54.5	2361112.0
2011-06-24 13:00:00	QQQ	ETF	54.5	54.55	54.4	54.5201	2125653.0

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

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