PREVIEW / etf_30min / 2012-01-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-01-12.parquet
  size:    288 KB
  rows:    9,596

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-01-12 04:00:00	SPY	ETF	129.06	129.15	129.01	129.15	5705.0
2012-01-12 04:30:00	SPY	ETF	129.2	129.3	129.2	129.3	5100.0
2012-01-12 05:00:00	SPY	ETF	129.54	129.79	129.54	129.7	23625.0
2012-01-12 05:30:00	SPY	ETF	129.7	129.87	129.66	129.87	26600.0
2012-01-12 06:00:00	SPY	ETF	129.85	129.93	129.72	129.84	67435.0
2012-01-12 06:30:00	SPY	ETF	129.83	129.95	129.7	129.9	88112.0
2012-01-12 07:00:00	SPY	ETF	129.9	130.13	129.82	129.94	153806.0
2012-01-12 07:30:00	SPY	ETF	129.95	130.18	129.95	130.0	275455.0
2012-01-12 08:00:00	SPY	ETF	129.96	129.99	129.83	129.95	814055.0
2012-01-12 08:30:00	SPY	ETF	129.93	129.99	129.34	129.47	3282800.0
2012-01-12 09:00:00	SPY	ETF	129.48	129.7	129.44	129.59	1667014.0
2012-01-12 09:30:00	SPY	ETF	129.57	129.7	129.1	129.31	18527224.0
2012-01-12 10:00:00	SPY	ETF	129.31	129.4	128.69	128.87	14211817.0
2012-01-12 10:30:00	SPY	ETF	128.87	128.9	128.54	128.74	10522781.0
2012-01-12 11:00:00	SPY	ETF	128.741	128.97	128.72	128.95	6433132.0
2012-01-12 11:30:00	SPY	ETF	128.95	129.08	128.86	129.025	5544876.0
2012-01-12 12:00:00	SPY	ETF	129.025	129.18	128.97	129.16	4179650.0
2012-01-12 12:30:00	SPY	ETF	129.16	129.31	129.12	129.26	4527774.0
2012-01-12 13:00:00	SPY	ETF	129.26	129.43	129.26	129.3	5541137.0
2012-01-12 13:30:00	SPY	ETF	129.2999	129.33	129.11	129.28	4563975.0
2012-01-12 14:00:00	SPY	ETF	129.29	129.34	129.12	129.24	4602525.0
2012-01-12 14:30:00	SPY	ETF	129.24	129.52	129.21	129.49	7261995.0
2012-01-12 15:00:00	SPY	ETF	129.49	129.57	129.36	129.5	6313833.0
2012-01-12 15:30:00	SPY	ETF	129.5	129.67	129.42	129.53	12738612.0
2012-01-12 16:00:00	SPY	ETF	129.53	129.65	129.02	129.63	5182941.0
2012-01-12 16:30:00	SPY	ETF	129.62	129.66	129.55	129.59	206850.0
2012-01-12 17:00:00	SPY	ETF	129.6	129.63	129.59	129.63	56241.0
2012-01-12 17:30:00	SPY	ETF	129.62	129.63	129.538	129.59	1726643.0
2012-01-12 18:00:00	SPY	ETF	129.59	129.65	129.51	129.62	113318.0
2012-01-12 18:30:00	SPY	ETF	129.63	129.65	129.61	129.65	17051.0
2012-01-12 19:00:00	SPY	ETF	129.65	129.7	129.64	129.7	34504.0
2012-01-12 19:30:00	SPY	ETF	129.69	129.85	129.69	129.76	200616.0
2012-01-12 05:00:00	QQQ	ETF	58.34	58.37	58.34	58.37	1000.0
2012-01-12 05:30:00	QQQ	ETF	58.39	58.39	58.39	58.39	1600.0
2012-01-12 06:00:00	QQQ	ETF	58.44	58.48	58.43	58.45	71582.0
2012-01-12 06:30:00	QQQ	ETF	58.4	58.41	58.39	58.41	32100.0
2012-01-12 07:00:00	QQQ	ETF	58.4	58.52	58.4	58.45	29600.0
2012-01-12 07:30:00	QQQ	ETF	58.45	58.49	58.42	58.42	62485.0
2012-01-12 08:00:00	QQQ	ETF	58.41	58.42	58.37	58.4	61582.0
2012-01-12 08:30:00	QQQ	ETF	58.4	58.4	58.22	58.26	426415.0
2012-01-12 09:00:00	QQQ	ETF	58.26	58.36	58.26	58.32	85667.0
2012-01-12 09:30:00	QQQ	ETF	58.29	58.35	58.06	58.18	4154608.0
2012-01-12 10:00:00	QQQ	ETF	58.17	58.22	57.89	58.04	4042526.0
2012-01-12 10:30:00	QQQ	ETF	58.05	58.05	57.86	57.99	2008215.0
2012-01-12 11:00:00	QQQ	ETF	57.99	58.185	57.98	58.18	1842896.0
2012-01-12 11:30:00	QQQ	ETF	58.18	58.25	58.12	58.2199	1463477.0
2012-01-12 12:00:00	QQQ	ETF	58.215	58.28	58.18	58.24	972175.0
2012-01-12 12:30:00	QQQ	ETF	58.24	58.29	58.21	58.26	1078378.0
2012-01-12 13:00:00	QQQ	ETF	58.27	58.335	58.265	58.289	1271172.0
2012-01-12 13:30:00	QQQ	ETF	58.29	58.32	58.2	58.3	499448.0

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

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