PREVIEW / etf_30min / 2009-11-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-27.parquet
  size:    158 KB
  rows:    4,964

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
2009-11-27 04:00:00	SPY	ETF	108.23	109.0	108.23	108.4	5199.0
2009-11-27 04:30:00	SPY	ETF	108.4	108.6	108.25	108.52	15808.0
2009-11-27 05:00:00	SPY	ETF	108.47	108.66	108.47	108.51	2101.0
2009-11-27 05:30:00	SPY	ETF	108.66	108.69	108.38	108.38	3600.0
2009-11-27 06:00:00	SPY	ETF	108.29	108.29	108.09	108.2	58927.0
2009-11-27 06:30:00	SPY	ETF	108.4	108.51	108.32	108.4	56744.0
2009-11-27 07:00:00	SPY	ETF	108.42	108.52	108.21	108.25	557486.0
2009-11-27 07:30:00	SPY	ETF	108.27	108.61	108.2	108.6	644434.0
2009-11-27 08:00:00	SPY	ETF	108.45	110.47	108.08	108.71	2637731.0
2009-11-27 08:30:00	SPY	ETF	108.71	111.14	108.5	108.51	1872826.0
2009-11-27 09:00:00	SPY	ETF	108.5	108.68	108.37	108.39	2902911.0
2009-11-27 09:30:00	SPY	ETF	108.4	109.28	108.29	109.22	32473373.0
2009-11-27 10:00:00	SPY	ETF	109.21	109.75	109.17	109.59	16763956.0
2009-11-27 10:30:00	SPY	ETF	109.6	110.18	109.45	109.99	12696732.0
2009-11-27 11:00:00	SPY	ETF	109.99	110.32	108.4	109.9025	11859155.0
2009-11-27 11:30:00	SPY	ETF	109.91	110.04	109.77	109.945	5908447.0
2009-11-27 12:00:00	SPY	ETF	109.94	109.97	109.61	109.72	7345309.0
2009-11-27 12:30:00	SPY	ETF	109.719	110.2	109.5	109.57	14199681.0
2009-11-27 13:00:00	SPY	ETF	109.56	111.4581	109.35	109.5	9448786.0
2009-11-27 13:30:00	SPY	ETF	109.5	111.4581	109.34	109.4	777132.0
2009-11-27 14:00:00	SPY	ETF	109.4	109.4	109.34	109.39	26800.0
2009-11-27 14:30:00	SPY	ETF	109.36	109.43	109.27	109.42	70873.0
2009-11-27 15:00:00	SPY	ETF	109.42	109.47	109.35	109.36	37667.0
2009-11-27 15:30:00	SPY	ETF	109.36	109.52	109.35	109.52	13582.0
2009-11-27 16:00:00	SPY	ETF	109.46	109.46	109.45	109.45	2650.0
2009-11-27 16:30:00	SPY	ETF	109.49	109.49	109.41	109.41	5150.0
2009-11-27 04:00:00	QQQ	ETF	43.03	43.03	43.03	43.03	100.0
2009-11-27 04:30:00	QQQ	ETF	43.0	43.0	43.0	43.0	320.0
2009-11-27 05:00:00	QQQ	ETF	43.03	43.03	43.03	43.03	2000.0
2009-11-27 05:30:00	QQQ	ETF	43.03	43.06	42.97	42.99	2229.0
2009-11-27 06:00:00	QQQ	ETF	42.89	42.95	42.88	42.88	2100.0
2009-11-27 06:30:00	QQQ	ETF	42.98	43.03	42.98	43.03	5651.0
2009-11-27 07:00:00	QQQ	ETF	43.04	43.07	42.97	42.97	119828.0
2009-11-27 07:30:00	QQQ	ETF	42.94	43.08	42.94	43.04	223647.0
2009-11-27 08:00:00	QQQ	ETF	43.07	43.82	43.04	43.17	800500.0
2009-11-27 08:30:00	QQQ	ETF	43.17	44.49	43.1	43.1	419578.0
2009-11-27 09:00:00	QQQ	ETF	43.1	43.18	42.99	42.99	820430.0
2009-11-27 09:30:00	QQQ	ETF	42.99	43.36	42.9	43.31	15645494.0
2009-11-27 10:00:00	QQQ	ETF	43.31	43.57	43.29	43.51	7306705.0
2009-11-27 10:30:00	QQQ	ETF	43.51	43.79	43.45	43.6965	6260840.0
2009-11-27 11:00:00	QQQ	ETF	43.69	43.83	43.645	43.71	8802744.0
2009-11-27 11:30:00	QQQ	ETF	43.71	43.75	43.635	43.7	4035173.0
2009-11-27 12:00:00	QQQ	ETF	43.7	43.7	43.52	43.56	4556314.0
2009-11-27 12:30:00	QQQ	ETF	43.55	43.78	43.5	43.52	6858106.0
2009-11-27 13:00:00	QQQ	ETF	43.53	43.5974	43.33	43.41	3001601.0
2009-11-27 13:30:00	QQQ	ETF	43.42	43.45	43.37	43.39	48635.0
2009-11-27 14:00:00	QQQ	ETF	43.39	43.41	43.38	43.41	11350.0
2009-11-27 14:30:00	QQQ	ETF	43.4	43.4	43.28	43.36	94228.0
2009-11-27 15:00:00	QQQ	ETF	43.36	43.45	43.36	43.42	6294.0
2009-11-27 15:30:00	QQQ	ETF	43.4	43.43	43.4	43.41	1416.0

> showing 50 of 4,964 rows — these rows as CSV

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