PREVIEW / etf_30min / 2012-08-13

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-13.parquet
  size:    270 KB
  rows:    9,071

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
2012-08-13 04:00:00	SPY	ETF	140.56	140.56	140.43	140.45	1700.0
2012-08-13 04:30:00	SPY	ETF	140.5	140.53	140.5	140.5	500.0
2012-08-13 05:00:00	SPY	ETF	140.7	140.73	140.7	140.73	300.0
2012-08-13 05:30:00	SPY	ETF	140.74	140.74	140.65	140.65	1900.0
2012-08-13 06:00:00	SPY	ETF	140.66	140.74	140.66	140.74	200.0
2012-08-13 06:30:00	SPY	ETF	140.8	140.84	140.74	140.84	24499.0
2012-08-13 07:00:00	SPY	ETF	140.83	141.0	140.83	140.9	117959.0
2012-08-13 07:30:00	SPY	ETF	140.9	140.93	140.8	140.81	57952.0
2012-08-13 08:00:00	SPY	ETF	140.84	140.9	140.68	140.75	220691.0
2012-08-13 08:30:00	SPY	ETF	140.75	140.81	140.67	140.71	229159.0
2012-08-13 09:00:00	SPY	ETF	140.71	140.74	140.53	140.59	892619.0
2012-08-13 09:30:00	SPY	ETF	140.6	140.84	140.47	140.69	8778331.0
2012-08-13 10:00:00	SPY	ETF	140.7	140.81	140.25	140.39	7958178.0
2012-08-13 10:30:00	SPY	ETF	140.39	140.4	140.21	140.21	6865266.0
2012-08-13 11:00:00	SPY	ETF	140.22	140.3	140.04	140.22	7423171.0
2012-08-13 11:30:00	SPY	ETF	140.22	140.32	140.18	140.26	3016005.0
2012-08-13 12:00:00	SPY	ETF	140.26	140.31	140.09	140.19	3832356.0
2012-08-13 12:30:00	SPY	ETF	140.19	140.41	140.12	140.39	3433202.0
2012-08-13 13:00:00	SPY	ETF	140.4	140.45	140.28	140.31	3239582.0
2012-08-13 13:30:00	SPY	ETF	140.31	140.47	140.25	140.405	3748150.0
2012-08-13 14:00:00	SPY	ETF	140.42	140.69	140.36	140.6	5471359.0
2012-08-13 14:30:00	SPY	ETF	140.61	140.81	140.57	140.711	4631201.0
2012-08-13 15:00:00	SPY	ETF	140.71	140.7525	140.54	140.55	4095072.0
2012-08-13 15:30:00	SPY	ETF	140.55	140.77	140.52	140.76	9628908.0
2012-08-13 16:00:00	SPY	ETF	140.77	140.91	140.3414	140.84	2853014.0
2012-08-13 16:30:00	SPY	ETF	140.83	140.8938	140.4805	140.8	246902.0
2012-08-13 17:00:00	SPY	ETF	140.8	140.88	140.8	140.87	34555.0
2012-08-13 17:30:00	SPY	ETF	140.87	140.87	140.83	140.86	21860.0
2012-08-13 18:00:00	SPY	ETF	140.88	140.88	140.82	140.82	18285.0
2012-08-13 18:30:00	SPY	ETF	140.82	140.82	140.76	140.77	15037.0
2012-08-13 19:00:00	SPY	ETF	140.77	140.8	140.77	140.8	21849.0
2012-08-13 19:30:00	SPY	ETF	140.82	140.83	140.77	140.78	19388.0
2012-08-13 05:00:00	QQQ	ETF	66.87	66.87	66.86	66.86	200.0
2012-08-13 06:30:00	QQQ	ETF	66.91	66.91	66.91	66.91	2500.0
2012-08-13 07:00:00	QQQ	ETF	66.92	66.99	66.92	66.92	18100.0
2012-08-13 07:30:00	QQQ	ETF	66.94	66.94	66.89	66.89	3500.0
2012-08-13 08:00:00	QQQ	ETF	66.89	66.91	66.86	66.88	200414.0
2012-08-13 08:30:00	QQQ	ETF	66.9	66.91	66.84	66.84	37840.0
2012-08-13 09:00:00	QQQ	ETF	66.88	66.89	66.81	66.83	109705.0
2012-08-13 09:30:00	QQQ	ETF	66.84	66.97	66.76	66.862	2648093.0
2012-08-13 10:00:00	QQQ	ETF	66.87	66.94	66.64	66.74	1755478.0
2012-08-13 10:30:00	QQQ	ETF	66.75	66.75	66.62	66.64	2448565.0
2012-08-13 11:00:00	QQQ	ETF	66.63	66.685	66.5	66.66	2662523.0
2012-08-13 11:30:00	QQQ	ETF	66.65	66.73	66.6199	66.69	499628.0
2012-08-13 12:00:00	QQQ	ETF	66.695	66.71	66.62	66.66	772978.0
2012-08-13 12:30:00	QQQ	ETF	66.66	66.828	66.65	66.82	961326.0
2012-08-13 13:00:00	QQQ	ETF	66.82	66.8401	66.7701	66.8	616115.0
2012-08-13 13:30:00	QQQ	ETF	66.8	66.87	66.77	66.83	536961.0
2012-08-13 14:00:00	QQQ	ETF	66.83	66.96	66.81	66.91	1189020.0
2012-08-13 14:30:00	QQQ	ETF	66.92	67.0095	66.91	66.95	1093770.0

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

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