PREVIEW / etf_30min / 2009-10-08

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-08.parquet
  size:    236 KB
  rows:    7,969

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-10-08 04:00:00	SPY	ETF	106.96	106.96	106.96	106.96	400.0
2009-10-08 04:30:00	SPY	ETF	106.84	106.84	106.79	106.79	600.0
2009-10-08 05:00:00	SPY	ETF	106.7	106.7	106.7	106.7	1554.0
2009-10-08 05:30:00	SPY	ETF	106.69	106.73	106.69	106.73	2500.0
2009-10-08 06:00:00	SPY	ETF	106.78	106.84	106.76	106.79	22850.0
2009-10-08 06:30:00	SPY	ETF	106.77	106.81	106.74	106.79	13500.0
2009-10-08 07:00:00	SPY	ETF	106.71	106.8	106.71	106.74	62476.0
2009-10-08 07:30:00	SPY	ETF	106.74	106.8	106.66	106.67	198911.0
2009-10-08 08:00:00	SPY	ETF	106.71	106.8	106.59	106.72	1013412.0
2009-10-08 08:30:00	SPY	ETF	106.74	107.02	106.7	106.8	3573787.0
2009-10-08 09:00:00	SPY	ETF	106.81	106.81	106.52	106.56	2375968.0
2009-10-08 09:30:00	SPY	ETF	106.55	106.8	106.315	106.47	26781945.0
2009-10-08 10:00:00	SPY	ETF	106.47	106.64	106.15	106.59	19003098.0
2009-10-08 10:30:00	SPY	ETF	106.58	106.75	106.52	106.67	9496600.0
2009-10-08 11:00:00	SPY	ETF	106.67	107.09	106.55	106.95	13157285.0
2009-10-08 11:30:00	SPY	ETF	106.96	107.12	106.95	107.02	9080199.0
2009-10-08 12:00:00	SPY	ETF	107.02	107.17	106.88	107.11	6637901.0
2009-10-08 12:30:00	SPY	ETF	107.11	107.17	106.65	107.06	6375429.0
2009-10-08 13:00:00	SPY	ETF	107.06	107.07	106.74	106.84	10168666.0
2009-10-08 13:30:00	SPY	ETF	106.84	106.91	106.56	106.84	9930759.0
2009-10-08 14:00:00	SPY	ETF	106.85	106.87	106.5	106.64	8220149.0
2009-10-08 14:30:00	SPY	ETF	106.64	106.82	106.57	106.72	6845930.0
2009-10-08 15:00:00	SPY	ETF	106.72	106.98	106.7	106.76	10524179.0
2009-10-08 15:30:00	SPY	ETF	106.75	106.8	106.51	106.61	26602793.0
2009-10-08 16:00:00	SPY	ETF	106.6	107.03	106.29	106.78	7221633.0
2009-10-08 16:30:00	SPY	ETF	106.79	106.95	106.75	106.89	1613584.0
2009-10-08 17:00:00	SPY	ETF	106.89	106.93	106.81	106.81	755621.0
2009-10-08 17:30:00	SPY	ETF	106.81	106.85	106.74	106.78	3124187.0
2009-10-08 18:00:00	SPY	ETF	106.79	106.85	106.79	106.85	67911.0
2009-10-08 18:30:00	SPY	ETF	106.85	106.92	106.82	106.87	15600.0
2009-10-08 19:00:00	SPY	ETF	106.87	106.89	106.77	106.88	22231.0
2009-10-08 19:30:00	SPY	ETF	106.88	106.92	106.87	106.92	18276.0
2009-10-08 04:00:00	QQQ	ETF	42.4	42.41	42.4	42.41	600.0
2009-10-08 06:00:00	QQQ	ETF	42.41	42.41	42.41	42.41	200.0
2009-10-08 06:30:00	QQQ	ETF	42.43	42.43	42.43	42.43	100.0
2009-10-08 07:00:00	QQQ	ETF	42.38	42.39	42.35	42.39	120600.0
2009-10-08 07:30:00	QQQ	ETF	42.39	42.39	42.35	42.35	140100.0
2009-10-08 08:00:00	QQQ	ETF	42.39	42.39	42.32	42.36	505775.0
2009-10-08 08:30:00	QQQ	ETF	42.37	42.45	42.35	42.4	1518074.0
2009-10-08 09:00:00	QQQ	ETF	42.4	42.41	42.24	42.31	1493359.0
2009-10-08 09:30:00	QQQ	ETF	42.31	42.46	42.25	42.32	13594746.0
2009-10-08 10:00:00	QQQ	ETF	42.32	42.36	42.14	42.3382	13020828.0
2009-10-08 10:30:00	QQQ	ETF	42.33	42.41	42.31	42.375	4706473.0
2009-10-08 11:00:00	QQQ	ETF	42.37	42.55	42.32	42.53	10229909.0
2009-10-08 11:30:00	QQQ	ETF	42.54	42.5974	42.49	42.5379	5215929.0
2009-10-08 12:00:00	QQQ	ETF	42.5301	42.62	42.47	42.58	3402585.0
2009-10-08 12:30:00	QQQ	ETF	42.59	42.61	42.35	42.54	3541316.0
2009-10-08 13:00:00	QQQ	ETF	42.54	42.54	42.4	42.43	7352575.0
2009-10-08 13:30:00	QQQ	ETF	42.43	42.45	42.29	42.42	6048886.0
2009-10-08 14:00:00	QQQ	ETF	42.41	42.44	42.25	42.29	2897328.0

> showing 50 of 7,969 rows — these rows as CSV

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