PREVIEW / etf_30min / 2007-11-21

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-21.parquet
  size:    142 KB
  rows:    5,239

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
2007-11-21 04:00:00	SPY	ETF	143.44	143.44	143.44	143.44	500.0
2007-11-21 05:00:00	SPY	ETF	142.98	142.98	142.61	142.83	8800.0
2007-11-21 05:30:00	SPY	ETF	142.83	143.01	142.83	142.88	22600.0
2007-11-21 06:00:00	SPY	ETF	142.88	143.09	142.84	143.06	72200.0
2007-11-21 06:30:00	SPY	ETF	143.06	143.08	142.89	143.08	96900.0
2007-11-21 07:00:00	SPY	ETF	143.13	143.33	142.98	143.0	407700.0
2007-11-21 07:30:00	SPY	ETF	143.0	143.0	142.68	142.76	1103400.0
2007-11-21 08:00:00	SPY	ETF	142.77	143.22	142.6	142.65	7737300.0
2007-11-21 08:30:00	SPY	ETF	142.65	143.25	142.65	143.15	2008300.0
2007-11-21 09:00:00	SPY	ETF	143.14	143.2	142.87	143.08	2890856.0
2007-11-21 09:30:00	SPY	ETF	143.08	143.38	142.56	143.08	28096943.0
2007-11-21 10:00:00	SPY	ETF	143.08	143.23	142.5	142.77	16419803.0
2007-11-21 10:30:00	SPY	ETF	142.76	142.85	141.88	142.12	26927223.0
2007-11-21 11:00:00	SPY	ETF	142.11	142.48	141.74	142.47	23247557.0
2007-11-21 11:30:00	SPY	ETF	142.47	143.07	142.29	142.55	21296172.0
2007-11-21 12:00:00	SPY	ETF	142.56	143.05	142.33	142.48	11470936.0
2007-11-21 12:30:00	SPY	ETF	142.47	143.55	142.29	143.4	15680827.0
2007-11-21 13:00:00	SPY	ETF	143.4	143.78	142.65	142.8	19484795.0
2007-11-21 13:30:00	SPY	ETF	142.77	143.1	142.51	142.9	6974530.0
2007-11-21 14:00:00	SPY	ETF	142.9	143.21	142.77	143.06	8320802.0
2007-11-21 14:30:00	SPY	ETF	143.06	143.71	143.04	143.71	7746286.0
2007-11-21 15:00:00	SPY	ETF	143.7	143.91	142.5	142.68	21567053.0
2007-11-21 15:30:00	SPY	ETF	142.67	142.92	141.76	141.81	22965026.0
2007-11-21 16:00:00	SPY	ETF	141.83	144.1972	141.67	141.75	6122500.0
2007-11-21 16:30:00	SPY	ETF	141.75	144.1969	141.68	141.82	2474100.0
2007-11-21 17:00:00	SPY	ETF	141.8	141.85	141.75	141.8	38800.0
2007-11-21 17:30:00	SPY	ETF	141.82	141.88	141.77	141.82	47300.0
2007-11-21 18:00:00	SPY	ETF	141.83	141.95	141.76	141.9	64100.0
2007-11-21 18:30:00	SPY	ETF	141.92	142.0	141.92	141.99	69500.0
2007-11-21 19:00:00	SPY	ETF	141.9	142.05	141.9	142.05	15900.0
2007-11-21 19:30:00	SPY	ETF	142.1	142.15	141.88	141.93	22500.0
2007-11-21 04:30:00	QQQ	ETF	49.55	49.55	49.42	49.44	2900.0
2007-11-21 05:00:00	QQQ	ETF	49.45	49.45	49.45	49.45	200.0
2007-11-21 05:30:00	QQQ	ETF	49.45	49.46	49.45	49.46	25000.0
2007-11-21 06:00:00	QQQ	ETF	49.4	49.5	49.4	49.45	28464.0
2007-11-21 06:30:00	QQQ	ETF	49.43	49.49	49.43	49.43	39500.0
2007-11-21 07:00:00	QQQ	ETF	49.47	49.53	49.44	49.44	659280.0
2007-11-21 07:30:00	QQQ	ETF	49.44	49.45	49.33	49.35	772105.0
2007-11-21 08:00:00	QQQ	ETF	49.35	49.5	49.33	49.35	1888560.0
2007-11-21 08:30:00	QQQ	ETF	49.36	49.42	49.33	49.4	1955844.0
2007-11-21 09:00:00	QQQ	ETF	49.41	49.44	49.38	49.44	658917.0
2007-11-21 09:30:00	QQQ	ETF	49.43	49.62	49.34	49.58	24649686.0
2007-11-21 10:00:00	QQQ	ETF	49.58	49.66	49.32	49.46	21804811.0
2007-11-21 10:30:00	QQQ	ETF	49.46	49.48	48.94	49.05	19976858.0
2007-11-21 11:00:00	QQQ	ETF	49.05	49.87	48.85	49.26	14200698.0
2007-11-21 11:30:00	QQQ	ETF	49.26	49.38	49.16	49.23	9612782.0
2007-11-21 12:00:00	QQQ	ETF	49.23	49.41	49.18	49.26	6748874.0
2007-11-21 12:30:00	QQQ	ETF	49.26	49.76	49.18	49.69	15759466.0
2007-11-21 13:00:00	QQQ	ETF	49.69	49.85	49.5	49.5501	10683761.0
2007-11-21 13:30:00	QQQ	ETF	49.56	49.7	49.48	49.66	11973038.0

> showing 50 of 5,239 rows — these rows as CSV

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