PREVIEW / etf_30min / 2010-10-22

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-22.parquet
  size:    246 KB
  rows:    8,291

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
2010-10-22 04:00:00	SPY	ETF	118.1	118.1	117.88	117.93	3600.0
2010-10-22 04:30:00	SPY	ETF	117.87	117.9	117.85	117.89	2700.0
2010-10-22 05:00:00	SPY	ETF	117.95	117.95	117.94	117.94	800.0
2010-10-22 05:30:00	SPY	ETF	117.93	117.93	117.93	117.93	200.0
2010-10-22 06:30:00	SPY	ETF	117.97	118.0	117.97	118.0	1500.0
2010-10-22 07:00:00	SPY	ETF	118.16	118.24	118.06	118.19	32985.0
2010-10-22 07:30:00	SPY	ETF	118.21	118.4	118.16	118.35	239325.0
2010-10-22 08:00:00	SPY	ETF	118.38	118.38	117.99	118.29	334169.0
2010-10-22 08:30:00	SPY	ETF	118.27	118.47	118.27	118.44	1123837.0
2010-10-22 09:00:00	SPY	ETF	118.44	118.57	118.29	118.3	1150007.0
2010-10-22 09:30:00	SPY	ETF	118.31	118.53	118.06	118.1	17694191.0
2010-10-22 10:00:00	SPY	ETF	118.1	118.33	118.0	118.33	11083786.0
2010-10-22 10:30:00	SPY	ETF	118.33	118.41	118.16	118.32	7285362.0
2010-10-22 11:00:00	SPY	ETF	118.32	118.38	118.125	118.1899	7080221.0
2010-10-22 11:30:00	SPY	ETF	118.19	118.33	118.07	118.12	8486975.0
2010-10-22 12:00:00	SPY	ETF	118.13	118.34	118.11	118.34	4162156.0
2010-10-22 12:30:00	SPY	ETF	118.33	118.36	118.21	118.27	3897672.0
2010-10-22 13:00:00	SPY	ETF	118.28	118.35	118.2	118.27	3292422.0
2010-10-22 13:30:00	SPY	ETF	118.27	118.28	118.09	118.11	3821758.0
2010-10-22 14:00:00	SPY	ETF	118.11	118.34	118.1	118.31	4398913.0
2010-10-22 14:30:00	SPY	ETF	118.31	118.32	118.16	118.205	5424995.0
2010-10-22 15:00:00	SPY	ETF	118.2	118.38	118.15	118.27	7471578.0
2010-10-22 15:30:00	SPY	ETF	118.26	118.42	118.19	118.38	16300176.0
2010-10-22 16:00:00	SPY	ETF	118.38	118.59	118.085	118.51	4144148.0
2010-10-22 16:30:00	SPY	ETF	118.51	118.57	118.45	118.51	371144.0
2010-10-22 17:00:00	SPY	ETF	118.52	118.57	118.5	118.55	147842.0
2010-10-22 17:30:00	SPY	ETF	118.51	118.54	118.51	118.52	25830.0
2010-10-22 18:00:00	SPY	ETF	118.52	118.52	118.46	118.5	6000.0
2010-10-22 18:30:00	SPY	ETF	118.53	118.55	118.45	118.54	54136.0
2010-10-22 19:00:00	SPY	ETF	118.5	118.51	118.5	118.5	1500.0
2010-10-22 19:30:00	SPY	ETF	118.53	118.55	118.48	118.55	13815.0
2010-10-22 05:30:00	QQQ	ETF	51.15	51.15	51.15	51.15	200.0
2010-10-22 06:00:00	QQQ	ETF	51.15	51.15	51.15	51.15	500.0
2010-10-22 07:00:00	QQQ	ETF	51.2	51.26	51.2	51.23	161880.0
2010-10-22 07:30:00	QQQ	ETF	51.25	51.34	51.25	51.3	206844.0
2010-10-22 08:00:00	QQQ	ETF	51.33	51.35	51.22	51.31	553791.0
2010-10-22 08:30:00	QQQ	ETF	51.3	51.4	51.3	51.38	374773.0
2010-10-22 09:00:00	QQQ	ETF	51.39	51.43	51.3	51.3	859773.0
2010-10-22 09:30:00	QQQ	ETF	51.3	51.54	51.21	51.39	8657421.0
2010-10-22 10:00:00	QQQ	ETF	51.38	51.44	51.29	51.4262	4777349.0
2010-10-22 10:30:00	QQQ	ETF	51.43	51.54	51.4	51.52	2540155.0
2010-10-22 11:00:00	QQQ	ETF	51.5138	51.58	51.46	51.51	2883527.0
2010-10-22 11:30:00	QQQ	ETF	51.52	51.6	51.48	51.519	2237285.0
2010-10-22 12:00:00	QQQ	ETF	51.51	51.66	51.5	51.6478	2109147.0
2010-10-22 12:30:00	QQQ	ETF	51.65	51.66	51.59	51.61	2268599.0
2010-10-22 13:00:00	QQQ	ETF	51.61	51.66	51.57	51.62	2273404.0
2010-10-22 13:30:00	QQQ	ETF	51.625	51.63	51.53	51.53	1274030.0
2010-10-22 14:00:00	QQQ	ETF	51.535	51.69	51.525	51.68	1881194.0
2010-10-22 14:30:00	QQQ	ETF	51.68	51.68	51.6	51.61	1930980.0
2010-10-22 15:00:00	QQQ	ETF	51.61	51.69	51.59	51.63	2885199.0

> showing 50 of 8,291 rows — these rows as CSV

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