PREVIEW / etf_30min / 2009-10-12

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-12.parquet
  size:    228 KB
  rows:    7,693

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-12 04:00:00	SPY	ETF	107.7	107.89	107.7	107.89	4500.0
2009-10-12 04:30:00	SPY	ETF	107.8	107.9	107.8	107.9	500.0
2009-10-12 05:00:00	SPY	ETF	107.93	107.98	107.86	107.9	3250.0
2009-10-12 05:30:00	SPY	ETF	107.86	107.9	107.83	107.9	13950.0
2009-10-12 06:00:00	SPY	ETF	107.92	107.92	107.85	107.92	36478.0
2009-10-12 06:30:00	SPY	ETF	107.92	107.95	107.87	107.95	28052.0
2009-10-12 07:00:00	SPY	ETF	107.94	108.13	107.94	107.97	164414.0
2009-10-12 07:30:00	SPY	ETF	107.99	108.03	107.95	107.98	267024.0
2009-10-12 08:00:00	SPY	ETF	107.97	107.97	107.81	107.91	841160.0
2009-10-12 08:30:00	SPY	ETF	107.91	107.92	107.76	107.81	528410.0
2009-10-12 09:00:00	SPY	ETF	107.81	107.83	107.74	107.76	611890.0
2009-10-12 09:30:00	SPY	ETF	107.76	108.07	107.65	108.06	14845212.0
2009-10-12 10:00:00	SPY	ETF	108.06	108.09	107.82	107.9	10359021.0
2009-10-12 10:30:00	SPY	ETF	107.9	108.04	107.89	108.02	6782224.0
2009-10-12 11:00:00	SPY	ETF	108.01	108.08	107.92	107.92	5220181.0
2009-10-12 11:30:00	SPY	ETF	107.92	107.93	107.83	107.85	4013087.0
2009-10-12 12:00:00	SPY	ETF	107.84	107.98	107.82	107.88	3808511.0
2009-10-12 12:30:00	SPY	ETF	107.88	107.96	107.82	107.95	3402357.0
2009-10-12 13:00:00	SPY	ETF	107.95	107.99	107.89	107.915	2516099.0
2009-10-12 13:30:00	SPY	ETF	107.92	107.98	107.83	107.9425	4947647.0
2009-10-12 14:00:00	SPY	ETF	107.95	107.965	107.38	107.46	17320017.0
2009-10-12 14:30:00	SPY	ETF	107.46	107.52	107.28	107.5	9675686.0
2009-10-12 15:00:00	SPY	ETF	107.5	107.65	107.495	107.64	7556742.0
2009-10-12 15:30:00	SPY	ETF	107.64	107.74	107.47	107.74	16512598.0
2009-10-12 16:00:00	SPY	ETF	107.74	108.0	107.44	107.58	7268591.0
2009-10-12 16:30:00	SPY	ETF	107.58	107.6	107.54	107.55	250634.0
2009-10-12 17:00:00	SPY	ETF	107.55	107.7	107.54	107.65	272268.0
2009-10-12 17:30:00	SPY	ETF	107.64	107.68	107.57	107.61	54600.0
2009-10-12 18:00:00	SPY	ETF	107.61	107.61	107.56	107.58	25298.0
2009-10-12 18:30:00	SPY	ETF	107.58	107.6	107.57	107.6	2711.0
2009-10-12 19:00:00	SPY	ETF	107.6	107.6	107.56	107.58	41073.0
2009-10-12 19:30:00	SPY	ETF	107.57	107.59	107.56	107.59	51062.0
2009-10-12 04:00:00	QQQ	ETF	42.63	42.68	42.63	42.67	998.0
2009-10-12 04:30:00	QQQ	ETF	42.7	42.7	42.7	42.7	100.0
2009-10-12 05:00:00	QQQ	ETF	42.71	42.74	42.71	42.74	3343.0
2009-10-12 06:00:00	QQQ	ETF	42.73	42.73	42.73	42.73	700.0
2009-10-12 06:30:00	QQQ	ETF	42.72	42.72	42.72	42.72	3000.0
2009-10-12 07:00:00	QQQ	ETF	42.74	42.78	42.73	42.74	133274.0
2009-10-12 07:30:00	QQQ	ETF	42.74	42.75	42.73	42.75	96206.0
2009-10-12 08:00:00	QQQ	ETF	42.73	42.75	42.7	42.74	139118.0
2009-10-12 08:30:00	QQQ	ETF	42.73	42.74	42.67	42.69	111423.0
2009-10-12 09:00:00	QQQ	ETF	42.69	42.71	42.65	42.65	247279.0
2009-10-12 09:30:00	QQQ	ETF	42.65	42.84	42.6	42.8301	8129904.0
2009-10-12 10:00:00	QQQ	ETF	42.84	42.87	42.74	42.7704	4921518.0
2009-10-12 10:30:00	QQQ	ETF	42.77	42.82	42.75	42.81	2451347.0
2009-10-12 11:00:00	QQQ	ETF	42.808	42.83	42.77	42.8	1727952.0
2009-10-12 11:30:00	QQQ	ETF	42.8021	42.8095	42.72	42.7301	1998093.0
2009-10-12 12:00:00	QQQ	ETF	42.73	42.735	42.65	42.66	2331929.0
2009-10-12 12:30:00	QQQ	ETF	42.65	42.69	42.63	42.68	2053777.0
2009-10-12 13:00:00	QQQ	ETF	42.67	42.7	42.64	42.65	1196789.0

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

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