PREVIEW / etf_30min / 2011-01-04

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-04.parquet
  size:    285 KB
  rows:    9,393

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-04 04:00:00	SPY	ETF	126.93	127.06	126.93	127.06	3366.0
2011-01-04 04:30:00	SPY	ETF	127.07	127.09	127.07	127.09	400.0
2011-01-04 05:00:00	SPY	ETF	127.15	127.15	127.07	127.07	200.0
2011-01-04 05:30:00	SPY	ETF	127.17	127.21	127.15	127.21	2362.0
2011-01-04 06:00:00	SPY	ETF	127.2	127.31	127.2	127.31	5750.0
2011-01-04 06:30:00	SPY	ETF	127.29	127.29	127.29	127.29	150.0
2011-01-04 07:00:00	SPY	ETF	127.29	127.34	127.29	127.31	58700.0
2011-01-04 07:30:00	SPY	ETF	127.32	127.33	127.22	127.25	112425.0
2011-01-04 08:00:00	SPY	ETF	127.23	127.28	127.12	127.12	793330.0
2011-01-04 08:30:00	SPY	ETF	127.13	127.18	127.07	127.12	326120.0
2011-01-04 09:00:00	SPY	ETF	127.13	127.35	127.05	127.33	1022363.0
2011-01-04 09:30:00	SPY	ETF	127.33	127.37	126.86	126.88	16592413.0
2011-01-04 10:00:00	SPY	ETF	126.88	126.99	126.7401	126.905	11678171.0
2011-01-04 10:30:00	SPY	ETF	126.91	126.95	126.68	126.72	8104656.0
2011-01-04 11:00:00	SPY	ETF	126.72	126.79	126.53	126.66	11096469.0
2011-01-04 11:30:00	SPY	ETF	126.66	126.8	126.57	126.5726	6160368.0
2011-01-04 12:00:00	SPY	ETF	126.58	126.62	126.27	126.325	8051019.0
2011-01-04 12:30:00	SPY	ETF	126.32	126.35	126.19	126.32	6572728.0
2011-01-04 13:00:00	SPY	ETF	126.32	126.56	126.31	126.53	7598478.0
2011-01-04 13:30:00	SPY	ETF	126.53	126.63	126.51	126.5725	6202444.0
2011-01-04 14:00:00	SPY	ETF	126.575	126.88	126.51	126.82	11752558.0
2011-01-04 14:30:00	SPY	ETF	126.82	126.86	126.725	126.745	7143112.0
2011-01-04 15:00:00	SPY	ETF	126.7495	126.96	126.66	126.87	7246216.0
2011-01-04 15:30:00	SPY	ETF	126.875	126.99	126.73	126.93	15279855.0
2011-01-04 16:00:00	SPY	ETF	126.93	127.1214	126.6	126.93	9058834.0
2011-01-04 16:30:00	SPY	ETF	126.93	126.94	126.6828	126.9	998479.0
2011-01-04 17:00:00	SPY	ETF	126.9	126.93	126.7086	126.85	184299.0
2011-01-04 17:30:00	SPY	ETF	126.87	126.96	126.83	126.91	134239.0
2011-01-04 18:00:00	SPY	ETF	126.9	126.93	126.82	126.87	62465.0
2011-01-04 18:30:00	SPY	ETF	126.88	126.88	126.82	126.82	18650.0
2011-01-04 19:00:00	SPY	ETF	126.86	126.86	126.83	126.85	19115.0
2011-01-04 19:30:00	SPY	ETF	126.85	126.88	126.82	126.82	14824.0
2011-01-04 04:30:00	QQQ	ETF	55.28	55.28	55.28	55.28	144.0
2011-01-04 05:30:00	QQQ	ETF	55.35	55.35	55.35	55.35	2000.0
2011-01-04 06:30:00	QQQ	ETF	55.4	55.44	55.4	55.44	500.0
2011-01-04 07:00:00	QQQ	ETF	55.43	55.46	55.43	55.46	7800.0
2011-01-04 07:30:00	QQQ	ETF	55.44	55.45	55.43	55.43	5572.0
2011-01-04 08:00:00	QQQ	ETF	55.45	55.48	55.41	55.44	514103.0
2011-01-04 08:30:00	QQQ	ETF	55.42	55.43	55.39	55.41	226870.0
2011-01-04 09:00:00	QQQ	ETF	55.41	55.56	55.41	55.53	389849.0
2011-01-04 09:30:00	QQQ	ETF	55.53	55.55	55.34	55.39	6031305.0
2011-01-04 10:00:00	QQQ	ETF	55.4	55.43	55.29	55.33	3423973.0
2011-01-04 10:30:00	QQQ	ETF	55.32	55.359	55.22	55.23	3265090.0
2011-01-04 11:00:00	QQQ	ETF	55.2325	55.27	55.11	55.14	3329490.0
2011-01-04 11:30:00	QQQ	ETF	55.14	55.175	55.05	55.0504	2328930.0
2011-01-04 12:00:00	QQQ	ETF	55.05	55.09	54.94	54.98	3319400.0
2011-01-04 12:30:00	QQQ	ETF	54.97	55.06	54.92	55.06	3219395.0
2011-01-04 13:00:00	QQQ	ETF	55.0585	55.13	55.04	55.11	2331845.0
2011-01-04 13:30:00	QQQ	ETF	55.11	55.135	55.08	55.11	904690.0
2011-01-04 14:00:00	QQQ	ETF	55.1165	55.3	55.09	55.28	2594792.0

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

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