PREVIEW / etf_30min / 2007-05-07

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-05-07.parquet
  size:    101 KB
  rows:    3,916

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-05-07 06:00:00	SPY	ETF	150.92	150.92	150.92	150.92	5000.0
2007-05-07 06:30:00	SPY	ETF	150.88	150.88	150.87	150.87	6900.0
2007-05-07 07:00:00	SPY	ETF	150.87	151.02	150.87	151.0	120300.0
2007-05-07 07:30:00	SPY	ETF	150.99	151.02	150.9	150.95	19400.0
2007-05-07 08:00:00	SPY	ETF	150.9	151.02	150.9	150.99	78200.0
2007-05-07 08:30:00	SPY	ETF	150.98	151.0	150.86	150.89	1526500.0
2007-05-07 09:00:00	SPY	ETF	150.88	150.94	150.8	150.87	436900.0
2007-05-07 09:30:00	SPY	ETF	150.88	151.2	150.81	151.05	14684034.0
2007-05-07 10:00:00	SPY	ETF	151.06	151.11	150.86	151.0	7243315.0
2007-05-07 10:30:00	SPY	ETF	151.0	151.06	150.84	150.99	6263823.0
2007-05-07 11:00:00	SPY	ETF	151.0	151.06	150.91	150.99	3453077.0
2007-05-07 11:30:00	SPY	ETF	151.0	151.07	150.94	150.97	3557126.0
2007-05-07 12:00:00	SPY	ETF	150.98	151.09	150.98	151.02	2693431.0
2007-05-07 12:30:00	SPY	ETF	151.03	151.03	150.91	150.98	2012119.0
2007-05-07 13:00:00	SPY	ETF	150.97	151.02	150.88	150.94	2242861.0
2007-05-07 13:30:00	SPY	ETF	150.94	151.06	150.9	150.99	1684840.0
2007-05-07 14:00:00	SPY	ETF	151.0	151.05	150.97	151.03	2028824.0
2007-05-07 14:30:00	SPY	ETF	151.04	151.05	150.99	151.02	2030972.0
2007-05-07 15:00:00	SPY	ETF	151.03	151.03	150.88	150.98	4333689.0
2007-05-07 15:30:00	SPY	ETF	150.98	151.0	150.88	150.96	5195298.0
2007-05-07 16:00:00	SPY	ETF	150.95	151.017	150.91	150.95	2458900.0
2007-05-07 16:30:00	SPY	ETF	150.94	151.0185	150.87	150.88	188100.0
2007-05-07 17:00:00	SPY	ETF	150.94	150.94	150.85	150.85	519800.0
2007-05-07 17:30:00	SPY	ETF	150.9	150.91	150.9	150.91	1500.0
2007-05-07 18:00:00	SPY	ETF	150.91	150.91	150.89	150.89	223400.0
2007-05-07 18:30:00	SPY	ETF	150.86	150.9	150.86	150.9	1400.0
2007-05-07 19:00:00	SPY	ETF	150.9	150.9	150.9	150.9	500.0
2007-05-07 19:30:00	SPY	ETF	150.93	150.93	150.93	150.93	1000.0
2007-05-07 07:00:00	QQQ	ETF	46.68	46.7	46.67	46.7	77512.0
2007-05-07 07:30:00	QQQ	ETF	46.68	46.69	46.64	46.64	13600.0
2007-05-07 08:00:00	QQQ	ETF	46.65	46.7	46.64	46.69	160867.0
2007-05-07 08:30:00	QQQ	ETF	46.7	46.7	46.65	46.66	34400.0
2007-05-07 09:00:00	QQQ	ETF	46.66	46.69	46.63	46.64	112283.0
2007-05-07 09:30:00	QQQ	ETF	46.65	46.78	46.62	46.71	12950691.0
2007-05-07 10:00:00	QQQ	ETF	46.71	46.73	46.65	46.7	5826413.0
2007-05-07 10:30:00	QQQ	ETF	46.71	46.76	46.66	46.71	3871174.0
2007-05-07 11:00:00	QQQ	ETF	46.72	46.73	46.68	46.72	2425412.0
2007-05-07 11:30:00	QQQ	ETF	46.71	46.73	46.69	46.71	1113426.0
2007-05-07 12:00:00	QQQ	ETF	46.72	46.7399	46.67	46.72	1725552.0
2007-05-07 12:30:00	QQQ	ETF	46.73	46.73	46.66	46.68	1954143.0
2007-05-07 13:00:00	QQQ	ETF	46.68	46.7	46.62	46.64	2077222.0
2007-05-07 13:30:00	QQQ	ETF	46.65	46.71	46.63	46.69	1187899.0
2007-05-07 14:00:00	QQQ	ETF	46.68	46.71	46.67	46.69	722242.0
2007-05-07 14:30:00	QQQ	ETF	46.69	46.7	46.66	46.68	820290.0
2007-05-07 15:00:00	QQQ	ETF	46.69	46.69	46.6	46.642	3850891.0
2007-05-07 15:30:00	QQQ	ETF	46.64	46.65	46.57	46.61	5420635.0
2007-05-07 16:00:00	QQQ	ETF	46.62	46.67	46.61	46.65	1776685.0
2007-05-07 16:30:00	QQQ	ETF	46.65	46.76	46.61	46.64	222285.0
2007-05-07 17:00:00	QQQ	ETF	46.64	46.65	46.61	46.61	415970.0
2007-05-07 17:30:00	QQQ	ETF	46.62	46.62	46.59	46.59	13200.0

> showing 50 of 3,916 rows — these rows as CSV

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