PREVIEW / etf_30min / 2011-08-03

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-03.parquet
  size:    314 KB
  rows:    10,379

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-08-03 04:00:00	SPY	ETF	125.71	126.17	125.71	126.17	7561.0
2011-08-03 04:30:00	SPY	ETF	125.97	125.97	125.88	125.88	1551.0
2011-08-03 05:00:00	SPY	ETF	125.94	126.0	125.94	126.0	200.0
2011-08-03 05:30:00	SPY	ETF	125.9	125.9	125.89	125.89	8600.0
2011-08-03 06:00:00	SPY	ETF	125.86	126.0	125.86	125.94	27370.0
2011-08-03 06:30:00	SPY	ETF	125.99	126.26	125.98	126.07	77150.0
2011-08-03 07:00:00	SPY	ETF	126.0	126.02	125.79	125.79	452845.0
2011-08-03 07:30:00	SPY	ETF	125.83	125.83	125.51	125.75	1013477.0
2011-08-03 08:00:00	SPY	ETF	125.76	125.95	125.12	125.88	3859180.0
2011-08-03 08:30:00	SPY	ETF	125.87	126.0	125.76	125.87	2065756.0
2011-08-03 09:00:00	SPY	ETF	125.87	125.97	125.58	125.66	2357072.0
2011-08-03 09:30:00	SPY	ETF	125.66	125.82	125.07	125.61	32000222.0
2011-08-03 10:00:00	SPY	ETF	125.61	125.91	124.52	124.81	37184054.0
2011-08-03 10:30:00	SPY	ETF	124.81	124.81	123.53	124.65	55118029.0
2011-08-03 11:00:00	SPY	ETF	124.61	125.37	124.37	124.929	37602201.0
2011-08-03 11:30:00	SPY	ETF	124.925	125.28	124.7	124.89	21539255.0
2011-08-03 12:00:00	SPY	ETF	124.89	124.92	124.19	124.41	19431504.0
2011-08-03 12:30:00	SPY	ETF	124.41	124.93	124.28	124.74	10330708.0
2011-08-03 13:00:00	SPY	ETF	124.75	125.0	124.47	124.95	10859573.0
2011-08-03 13:30:00	SPY	ETF	124.95	126.04	124.94	125.62	23782513.0
2011-08-03 14:00:00	SPY	ETF	125.62	125.92	125.22	125.3	18410201.0
2011-08-03 14:30:00	SPY	ETF	125.315	125.73	125.0978	125.62	14946375.0
2011-08-03 15:00:00	SPY	ETF	125.63	126.23	125.39	125.97	28171984.0
2011-08-03 15:30:00	SPY	ETF	125.97	126.31	125.72	126.2	32616383.0
2011-08-03 16:00:00	SPY	ETF	126.22	126.22	125.1161	125.95	11677803.0
2011-08-03 16:30:00	SPY	ETF	125.95	126.21	124.7471	126.0	3426790.0
2011-08-03 17:00:00	SPY	ETF	125.98	126.09	125.95	126.01	422927.0
2011-08-03 17:30:00	SPY	ETF	126.04	126.15	125.95	126.13	183806.0
2011-08-03 18:00:00	SPY	ETF	126.11	126.21	126.0	126.09	170720.0
2011-08-03 18:30:00	SPY	ETF	126.1	126.24	126.09	126.24	147349.0
2011-08-03 19:00:00	SPY	ETF	126.25	126.33	126.22	126.3	163982.0
2011-08-03 19:30:00	SPY	ETF	126.3	126.42	126.28	126.37	155088.0
2011-08-03 04:00:00	QQQ	ETF	56.43	56.43	56.43	56.43	200.0
2011-08-03 06:00:00	QQQ	ETF	56.44	56.54	56.44	56.54	1300.0
2011-08-03 06:30:00	QQQ	ETF	56.5	56.57	56.5	56.51	3759.0
2011-08-03 07:00:00	QQQ	ETF	56.48	56.55	56.45	56.45	45575.0
2011-08-03 07:30:00	QQQ	ETF	56.42	56.42	56.31	56.37	49775.0
2011-08-03 08:00:00	QQQ	ETF	56.36	56.64	56.26	56.45	538298.0
2011-08-03 08:30:00	QQQ	ETF	56.45	56.49	56.4	56.44	376092.0
2011-08-03 09:00:00	QQQ	ETF	56.44	56.48	56.33	56.36	759765.0
2011-08-03 09:30:00	QQQ	ETF	56.37	56.54	56.14	56.51	7893371.0
2011-08-03 10:00:00	QQQ	ETF	56.52	56.6	55.81	55.95	10495388.0
2011-08-03 10:30:00	QQQ	ETF	55.94	55.97	55.35	55.9505	16295091.0
2011-08-03 11:00:00	QQQ	ETF	55.96	56.36	55.85	56.21	10036493.0
2011-08-03 11:30:00	QQQ	ETF	56.21	56.44	56.14	56.2383	5194343.0
2011-08-03 12:00:00	QQQ	ETF	56.24	56.25	55.87	56.02	4683820.0
2011-08-03 12:30:00	QQQ	ETF	56.02	56.26	55.96	56.16	1857102.0
2011-08-03 13:00:00	QQQ	ETF	56.16	56.31	56.01	56.309	5748435.0
2011-08-03 13:30:00	QQQ	ETF	56.31	56.75	56.291	56.5801	6079653.0
2011-08-03 14:00:00	QQQ	ETF	56.5814	56.73	56.43	56.47	5216789.0

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

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