PREVIEW / etf_30min / 2011-03-15

all etf 30-min files

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

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-03-15 04:00:00	SPY	ETF	127.75	128.2	127.51	128.03	191300.0
2011-03-15 04:30:00	SPY	ETF	128.09	128.12	127.64	127.75	115629.0
2011-03-15 05:00:00	SPY	ETF	127.65	127.67	126.61	126.8	87612.0
2011-03-15 05:30:00	SPY	ETF	126.8	127.3	126.75	126.87	116957.0
2011-03-15 06:00:00	SPY	ETF	126.87	127.18	125.8	126.83	158150.0
2011-03-15 06:30:00	SPY	ETF	126.85	126.98	126.55	126.76	790662.0
2011-03-15 07:00:00	SPY	ETF	126.85	127.32	126.84	127.11	1972078.0
2011-03-15 07:30:00	SPY	ETF	127.07	127.16	126.63	126.87	2596591.0
2011-03-15 08:00:00	SPY	ETF	126.84	127.9	126.65	126.83	6636189.0
2011-03-15 08:30:00	SPY	ETF	126.82	127.79	126.4	126.66	4332572.0
2011-03-15 09:00:00	SPY	ETF	126.67	127.08	126.48	126.59	5693174.0
2011-03-15 09:30:00	SPY	ETF	126.59	127.47	126.5	126.83	50855178.0
2011-03-15 10:00:00	SPY	ETF	126.84	128.4	126.8	127.78	28607442.0
2011-03-15 10:30:00	SPY	ETF	127.765	127.91	127.49	127.8	24442166.0
2011-03-15 11:00:00	SPY	ETF	127.795	127.9	127.46	127.86	13637168.0
2011-03-15 11:30:00	SPY	ETF	127.86	127.97	127.68	127.9	13244663.0
2011-03-15 12:00:00	SPY	ETF	127.91	128.52	127.87	128.461	15278686.0
2011-03-15 12:30:00	SPY	ETF	128.47	128.475	127.78	128.07	16518525.0
2011-03-15 13:00:00	SPY	ETF	128.07	128.14	127.22	127.885	13242853.0
2011-03-15 13:30:00	SPY	ETF	127.885	128.25	127.88	128.24	11205981.0
2011-03-15 14:00:00	SPY	ETF	128.24	128.69	127.88	128.638	19161442.0
2011-03-15 14:30:00	SPY	ETF	128.625	128.87	128.45	128.57	18798995.0
2011-03-15 15:00:00	SPY	ETF	128.57	129.17	128.5233	129.05	14901213.0
2011-03-15 15:30:00	SPY	ETF	129.055	129.33	128.6	128.63	31152062.0
2011-03-15 16:00:00	SPY	ETF	128.62	130.0974	127.25	128.38	24125681.0
2011-03-15 16:30:00	SPY	ETF	128.4	130.0975	126.6441	128.43	26825649.0
2011-03-15 17:00:00	SPY	ETF	128.41	130.0974	128.36	128.38	10591326.0
2011-03-15 17:30:00	SPY	ETF	128.4	128.47	128.35	128.38	59696.0
2011-03-15 18:00:00	SPY	ETF	128.39	128.65	127.9	128.0	788945.0
2011-03-15 18:30:00	SPY	ETF	128.03	128.03	127.52	127.92	595069.0
2011-03-15 19:00:00	SPY	ETF	127.9	128.31	127.9	128.31	228251.0
2011-03-15 19:30:00	SPY	ETF	128.24	128.61	128.1	128.48	250189.0
2011-03-15 04:00:00	QQQ	ETF	55.8	55.8	55.34	55.52	5782.0
2011-03-15 04:30:00	QQQ	ETF	55.48	55.48	55.34	55.35	4200.0
2011-03-15 05:00:00	QQQ	ETF	55.3	55.49	54.76	54.76	5512.0
2011-03-15 05:30:00	QQQ	ETF	54.86	54.86	54.69	54.74	18070.0
2011-03-15 06:00:00	QQQ	ETF	54.81	54.87	54.77	54.84	6600.0
2011-03-15 06:30:00	QQQ	ETF	54.78	54.86	54.7	54.86	32881.0
2011-03-15 07:00:00	QQQ	ETF	54.9	55.13	54.9	55.07	393385.0
2011-03-15 07:30:00	QQQ	ETF	55.08	55.11	54.73	54.84	1082693.0
2011-03-15 08:00:00	QQQ	ETF	54.81	54.89	54.75	54.8	1678222.0
2011-03-15 08:30:00	QQQ	ETF	54.85	54.86	54.58	54.74	1189561.0
2011-03-15 09:00:00	QQQ	ETF	54.75	54.92	54.59	54.64	2518801.0
2011-03-15 09:30:00	QQQ	ETF	54.64	55.03	54.47	54.68	19645623.0
2011-03-15 10:00:00	QQQ	ETF	54.68	55.065	54.63	55.06	8377536.0
2011-03-15 10:30:00	QQQ	ETF	55.06	55.26	54.955	55.2	6966207.0
2011-03-15 11:00:00	QQQ	ETF	55.21	55.27	55.05	55.24	5522432.0
2011-03-15 11:30:00	QQQ	ETF	55.235	55.35	55.2	55.31	4022574.0
2011-03-15 12:00:00	QQQ	ETF	55.32	55.54	55.29	55.54	4536000.0
2011-03-15 12:30:00	QQQ	ETF	55.53	55.5384	55.17	55.33	6482613.0

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

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