PREVIEW / etf_30min / 2011-01-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-25.parquet
  size:    279 KB
  rows:    9,255

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-01-25 04:00:00	SPY	ETF	129.1	129.2	129.1	129.12	4245.0
2011-01-25 04:30:00	SPY	ETF	129.0	129.0	128.7	128.7	2719.0
2011-01-25 05:00:00	SPY	ETF	128.81	128.86	128.81	128.86	20100.0
2011-01-25 05:30:00	SPY	ETF	128.75	128.75	128.7	128.7	17894.0
2011-01-25 06:00:00	SPY	ETF	128.68	128.86	128.68	128.86	5666.0
2011-01-25 06:30:00	SPY	ETF	128.88	128.89	128.78	128.87	32400.0
2011-01-25 07:00:00	SPY	ETF	128.85	128.85	128.73	128.82	166751.0
2011-01-25 07:30:00	SPY	ETF	128.81	128.89	128.68	128.68	549557.0
2011-01-25 08:00:00	SPY	ETF	128.72	128.72	128.58	128.69	507171.0
2011-01-25 08:30:00	SPY	ETF	128.7	128.74	128.59	128.59	536458.0
2011-01-25 09:00:00	SPY	ETF	128.6	128.79	128.59	128.75	986472.0
2011-01-25 09:30:00	SPY	ETF	128.76	129.16	128.6	129.16	12506127.0
2011-01-25 10:00:00	SPY	ETF	129.16	129.28	128.65	128.73	15157267.0
2011-01-25 10:30:00	SPY	ETF	128.73	129.04	128.72	128.97	7622384.0
2011-01-25 11:00:00	SPY	ETF	128.97	128.99	128.32	128.34	17475382.0
2011-01-25 11:30:00	SPY	ETF	128.34	128.45	128.22	128.37	9931965.0
2011-01-25 12:00:00	SPY	ETF	128.37	128.82	128.36	128.74	9075688.0
2011-01-25 12:30:00	SPY	ETF	128.75	128.87	128.695	128.74	8193237.0
2011-01-25 13:00:00	SPY	ETF	128.7499	128.79	128.54	128.63	6311381.0
2011-01-25 13:30:00	SPY	ETF	128.625	128.75	128.51	128.7	5189497.0
2011-01-25 14:00:00	SPY	ETF	128.7	129.1281	128.11	128.24	13848449.0
2011-01-25 14:30:00	SPY	ETF	128.24	128.44	128.135	128.36	11214059.0
2011-01-25 15:00:00	SPY	ETF	128.36	128.9	128.34	128.87	14761045.0
2011-01-25 15:30:00	SPY	ETF	128.86	129.18	128.68	129.14	21587198.0
2011-01-25 16:00:00	SPY	ETF	129.14	129.2	128.635	129.13	7455842.0
2011-01-25 16:30:00	SPY	ETF	129.12	129.13	129.06	129.09	2373694.0
2011-01-25 17:00:00	SPY	ETF	129.08	129.15	129.06	129.14	145024.0
2011-01-25 17:30:00	SPY	ETF	129.14	129.14	129.085	129.11	88975.0
2011-01-25 18:00:00	SPY	ETF	129.12	129.13	129.03	129.07	99341.0
2011-01-25 18:30:00	SPY	ETF	129.07	129.08	129.03	129.06	19526.0
2011-01-25 19:00:00	SPY	ETF	129.03	129.11	129.01	129.1	25801.0
2011-01-25 19:30:00	SPY	ETF	129.09	129.14	129.09	129.14	32875.0
2011-01-25 05:00:00	QQQ	ETF	56.2	56.21	56.2	56.21	1090.0
2011-01-25 05:30:00	QQQ	ETF	56.17	56.17	56.15	56.15	3400.0
2011-01-25 06:30:00	QQQ	ETF	56.22	56.23	56.22	56.23	40000.0
2011-01-25 07:00:00	QQQ	ETF	56.24	56.24	56.2	56.21	16045.0
2011-01-25 07:30:00	QQQ	ETF	56.26	56.26	56.18	56.2	62155.0
2011-01-25 08:00:00	QQQ	ETF	56.2	56.2	56.14	56.19	165054.0
2011-01-25 08:30:00	QQQ	ETF	56.19	56.19	56.04	56.06	462713.0
2011-01-25 09:00:00	QQQ	ETF	56.06	56.22	56.06	56.18	389607.0
2011-01-25 09:30:00	QQQ	ETF	56.18	56.4	56.08	56.36	6349088.0
2011-01-25 10:00:00	QQQ	ETF	56.36	56.44	56.18	56.25	4786688.0
2011-01-25 10:30:00	QQQ	ETF	56.25	56.46	56.24	56.42	3509201.0
2011-01-25 11:00:00	QQQ	ETF	56.4155	56.42	56.135	56.17	4349070.0
2011-01-25 11:30:00	QQQ	ETF	56.16	56.24	56.11	56.18	2371315.0
2011-01-25 12:00:00	QQQ	ETF	56.18	56.39	56.18	56.36	2343479.0
2011-01-25 12:30:00	QQQ	ETF	56.36	56.43	56.32	56.375	1489162.0
2011-01-25 13:00:00	QQQ	ETF	56.38	56.39	56.28	56.31	1646582.0
2011-01-25 13:30:00	QQQ	ETF	56.3017	56.375	56.27	56.3399	1054287.0
2011-01-25 14:00:00	QQQ	ETF	56.34	56.34	56.05	56.095	4311100.0

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

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