PREVIEW / etf_30min / 2011-01-03

all etf 30-min files

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

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-03 04:00:00	SPY	ETF	126.35	126.45	126.3	126.3	3279.0
2011-01-03 04:30:00	SPY	ETF	126.4	126.4	126.4	126.4	118.0
2011-01-03 05:00:00	SPY	ETF	126.44	126.44	126.44	126.44	100.0
2011-01-03 05:30:00	SPY	ETF	126.48	126.5	126.44	126.48	3500.0
2011-01-03 06:00:00	SPY	ETF	126.49	126.51	126.49	126.49	1275.0
2011-01-03 06:30:00	SPY	ETF	126.46	126.47	126.44	126.45	5800.0
2011-01-03 07:00:00	SPY	ETF	126.45	126.51	126.35	126.5	143127.0
2011-01-03 07:30:00	SPY	ETF	126.5	126.81	126.5	126.73	433445.0
2011-01-03 08:00:00	SPY	ETF	126.71	126.78	125.05	126.7	710420.0
2011-01-03 08:30:00	SPY	ETF	126.7	126.71	125.69	126.66	531268.0
2011-01-03 09:00:00	SPY	ETF	126.66	126.73	125.75	126.71	1017708.0
2011-01-03 09:30:00	SPY	ETF	126.71	127.15	126.66	127.13	18631441.0
2011-01-03 10:00:00	SPY	ETF	127.14	127.29	126.97	127.2	11948902.0
2011-01-03 10:30:00	SPY	ETF	127.2	127.43	127.14	127.4	7179519.0
2011-01-03 11:00:00	SPY	ETF	127.4	127.46	127.32	127.435	7239391.0
2011-01-03 11:30:00	SPY	ETF	127.4325	127.6	127.37	127.475	6661523.0
2011-01-03 12:00:00	SPY	ETF	127.47	127.55	127.46	127.48	4005332.0
2011-01-03 12:30:00	SPY	ETF	127.48	127.52	127.35	127.42	6028886.0
2011-01-03 13:00:00	SPY	ETF	127.42	127.46	127.37	127.385	4594881.0
2011-01-03 13:30:00	SPY	ETF	127.38	127.45	127.35	127.447	3490793.0
2011-01-03 14:00:00	SPY	ETF	127.45	127.48	127.27	127.2799	5510060.0
2011-01-03 14:30:00	SPY	ETF	127.28	127.36	127.2	127.29	7832449.0
2011-01-03 15:00:00	SPY	ETF	127.29	127.3	127.02	127.07	11559043.0
2011-01-03 15:30:00	SPY	ETF	127.07	127.3	127.04	127.05	22883018.0
2011-01-03 16:00:00	SPY	ETF	127.04	127.525	125.6986	126.88	12035012.0
2011-01-03 16:30:00	SPY	ETF	126.87	126.92	126.85	126.92	242725.0
2011-01-03 17:00:00	SPY	ETF	126.91	126.93	126.89	126.9	34400.0
2011-01-03 17:30:00	SPY	ETF	126.92	126.94	126.9	126.91	19170.0
2011-01-03 18:00:00	SPY	ETF	126.91	127.01	126.88	126.97	81096.0
2011-01-03 18:30:00	SPY	ETF	126.97	126.97	126.91	126.95	32654.0
2011-01-03 19:00:00	SPY	ETF	126.94	126.94	126.88	126.88	91345.0
2011-01-03 19:30:00	SPY	ETF	126.88	126.91	126.87	126.9	26283.0
2011-01-03 04:00:00	QQQ	ETF	54.76	54.76	54.75	54.75	300.0
2011-01-03 04:30:00	QQQ	ETF	54.78	54.78	54.78	54.78	400.0
2011-01-03 05:00:00	QQQ	ETF	54.8	54.84	54.8	54.84	400.0
2011-01-03 06:00:00	QQQ	ETF	54.85	54.86	54.85	54.86	3400.0
2011-01-03 06:30:00	QQQ	ETF	54.85	54.85	54.85	54.85	300.0
2011-01-03 07:00:00	QQQ	ETF	54.85	54.86	54.81	54.85	20016.0
2011-01-03 07:30:00	QQQ	ETF	54.85	55.03	54.85	54.99	93436.0
2011-01-03 08:00:00	QQQ	ETF	54.98	55.02	54.97	54.99	821204.0
2011-01-03 08:30:00	QQQ	ETF	55.0	55.0	54.94	54.96	143473.0
2011-01-03 09:00:00	QQQ	ETF	54.96	54.98	54.95	54.96	375611.0
2011-01-03 09:30:00	QQQ	ETF	54.96	55.37	54.95	55.34	13668327.0
2011-01-03 10:00:00	QQQ	ETF	55.33	55.605	55.29	55.51	11244493.0
2011-01-03 10:30:00	QQQ	ETF	55.52	55.64	55.49	55.6101	5783711.0
2011-01-03 11:00:00	QQQ	ETF	55.61	55.64	55.53	55.6	3234991.0
2011-01-03 11:30:00	QQQ	ETF	55.6	55.69	55.56	55.579	3185212.0
2011-01-03 12:00:00	QQQ	ETF	55.58	55.61	55.52	55.53	3764384.0
2011-01-03 12:30:00	QQQ	ETF	55.53	55.54	55.425	55.4498	3642405.0
2011-01-03 13:00:00	QQQ	ETF	55.45	55.47	55.39	55.43	2449930.0

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

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