PREVIEW / etf_30min / 2011-03-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-16.parquet
  size:    307 KB
  rows:    10,039

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-16 04:00:00	SPY	ETF	128.7	128.87	128.68	128.74	2700.0
2011-03-16 04:30:00	SPY	ETF	128.55	128.82	128.55	128.8	1750.0
2011-03-16 05:00:00	SPY	ETF	128.72	128.74	128.72	128.74	1100.0
2011-03-16 05:30:00	SPY	ETF	128.57	128.57	128.18	128.36	12750.0
2011-03-16 06:00:00	SPY	ETF	128.39	128.39	127.9	128.16	29565.0
2011-03-16 06:30:00	SPY	ETF	128.1	128.18	127.78	128.13	295050.0
2011-03-16 07:00:00	SPY	ETF	128.09	128.31	128.0	128.31	312873.0
2011-03-16 07:30:00	SPY	ETF	128.3	128.38	128.08	128.33	1147909.0
2011-03-16 08:00:00	SPY	ETF	128.34	128.9	127.77	128.62	1941614.0
2011-03-16 08:30:00	SPY	ETF	128.62	128.65	128.21	128.52	2168223.0
2011-03-16 09:00:00	SPY	ETF	128.52	128.6	128.14	128.16	2528611.0
2011-03-16 09:30:00	SPY	ETF	128.15	128.3	127.69	128.09	27987681.0
2011-03-16 10:00:00	SPY	ETF	128.09	128.41	128.04	128.309	15327621.0
2011-03-16 10:30:00	SPY	ETF	128.31	128.57	127.8	127.82	16727254.0
2011-03-16 11:00:00	SPY	ETF	127.83	127.86	126.51	127.59	77602748.0
2011-03-16 11:30:00	SPY	ETF	127.59	127.8	127.07	127.17	21487894.0
2011-03-16 12:00:00	SPY	ETF	127.16	127.32	126.6	127.21	37792285.0
2011-03-16 12:30:00	SPY	ETF	127.2	127.31	126.79	127.14	21478295.0
2011-03-16 13:00:00	SPY	ETF	127.14	127.32	126.71	126.8625	13420432.0
2011-03-16 13:30:00	SPY	ETF	126.86	126.91	126.415	126.541	16657046.0
2011-03-16 14:00:00	SPY	ETF	126.54	126.57	125.28	126.0	50340716.0
2011-03-16 14:30:00	SPY	ETF	126.01	127.23	125.91	126.95	38741766.0
2011-03-16 15:00:00	SPY	ETF	126.94	127.21	126.37	126.59	32021724.0
2011-03-16 15:30:00	SPY	ETF	126.59	126.69	126.11	126.21	35815972.0
2011-03-16 16:00:00	SPY	ETF	126.21	128.6509	126.08	126.38	17463653.0
2011-03-16 16:30:00	SPY	ETF	126.4	127.148	125.876	126.22	14818047.0
2011-03-16 17:00:00	SPY	ETF	126.25	126.27	125.58	125.84	11411223.0
2011-03-16 17:30:00	SPY	ETF	125.81	126.153	125.62	125.7	1330002.0
2011-03-16 18:00:00	SPY	ETF	125.73	125.78	125.14	125.59	1552873.0
2011-03-16 18:30:00	SPY	ETF	125.6	125.76	125.24	125.6	506630.0
2011-03-16 19:00:00	SPY	ETF	125.59	125.74	125.42	125.5	861754.0
2011-03-16 19:30:00	SPY	ETF	125.57	126.23	125.55	126.04	379492.0
2011-03-16 04:00:00	QQQ	ETF	55.48	55.55	55.48	55.54	4800.0
2011-03-16 04:30:00	QQQ	ETF	55.57	55.57	55.57	55.57	928.0
2011-03-16 05:00:00	QQQ	ETF	55.51	55.51	55.43	55.43	1200.0
2011-03-16 05:30:00	QQQ	ETF	55.36	55.36	55.25	55.34	2400.0
2011-03-16 06:00:00	QQQ	ETF	55.2	55.2	55.16	55.2	1200.0
2011-03-16 06:30:00	QQQ	ETF	55.14	55.2	55.05	55.16	11158.0
2011-03-16 07:00:00	QQQ	ETF	55.16	55.23	55.13	55.22	43378.0
2011-03-16 07:30:00	QQQ	ETF	55.25	55.3	55.14	55.24	48208.0
2011-03-16 08:00:00	QQQ	ETF	55.27	55.43	55.2	55.2	217265.0
2011-03-16 08:30:00	QQQ	ETF	55.4	55.4	55.15	55.28	533464.0
2011-03-16 09:00:00	QQQ	ETF	55.31	55.34	55.02	55.04	1080610.0
2011-03-16 09:30:00	QQQ	ETF	55.03	55.26	54.96	55.1	18301446.0
2011-03-16 10:00:00	QQQ	ETF	55.1	55.3	55.09	55.2581	11133823.0
2011-03-16 10:30:00	QQQ	ETF	55.26	55.34	55.0	55.0	7066554.0
2011-03-16 11:00:00	QQQ	ETF	55.005	55.01	54.41	54.77	27938277.0
2011-03-16 11:30:00	QQQ	ETF	54.77	54.85	54.47	54.49	10111699.0
2011-03-16 12:00:00	QQQ	ETF	54.5	54.65	54.32	54.6099	18022248.0
2011-03-16 12:30:00	QQQ	ETF	54.61	54.69	54.46	54.632	6204247.0

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

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