PREVIEW / etf_30min / 2007-06-07

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-07.parquet
  size:    131 KB
  rows:    4,756

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-06-07 04:00:00	SPY	ETF	152.32	152.35	152.32	152.35	3000.0
2007-06-07 04:30:00	SPY	ETF	152.47	152.47	152.47	152.47	100.0
2007-06-07 05:30:00	SPY	ETF	152.23	152.23	152.23	152.23	1000.0
2007-06-07 06:00:00	SPY	ETF	152.2	152.2	152.2	152.2	1000.0
2007-06-07 06:30:00	SPY	ETF	152.27	152.27	152.22	152.22	40000.0
2007-06-07 07:00:00	SPY	ETF	152.33	152.33	152.08	152.09	170300.0
2007-06-07 07:30:00	SPY	ETF	152.04	152.13	151.78	151.79	968200.0
2007-06-07 08:00:00	SPY	ETF	151.81	152.5	151.49	151.7	1635900.0
2007-06-07 08:30:00	SPY	ETF	151.7	151.79	151.51	151.65	1232800.0
2007-06-07 09:00:00	SPY	ETF	151.68	151.68	151.53	151.57	399900.0
2007-06-07 09:30:00	SPY	ETF	151.56	152.0	151.46	152.0	20619496.0
2007-06-07 10:00:00	SPY	ETF	152.0	152.06	151.46	151.5	15136299.0
2007-06-07 10:30:00	SPY	ETF	151.49	151.87	151.25	151.38	16239273.0
2007-06-07 11:00:00	SPY	ETF	151.39	151.42	150.74	151.01	22429482.0
2007-06-07 11:30:00	SPY	ETF	151.01	151.24	150.92	150.95	9115900.0
2007-06-07 12:00:00	SPY	ETF	150.95	152.5	150.79	151.07	8176083.0
2007-06-07 12:30:00	SPY	ETF	151.06	151.13	150.27	150.6	22149800.0
2007-06-07 13:00:00	SPY	ETF	150.59	150.67	150.12	150.26	11583933.0
2007-06-07 13:30:00	SPY	ETF	150.28	150.3	149.67	150.13	18715879.0
2007-06-07 14:00:00	SPY	ETF	150.135	150.17	149.66	149.94	12622594.0
2007-06-07 14:30:00	SPY	ETF	149.94	150.48	149.73	150.25	15524402.0
2007-06-07 15:00:00	SPY	ETF	150.2499	150.65	150.15	150.24	19562811.0
2007-06-07 15:30:00	SPY	ETF	150.24	150.48	149.25	149.36	21243708.0
2007-06-07 16:00:00	SPY	ETF	149.36	149.55	149.05	149.12	5098500.0
2007-06-07 16:30:00	SPY	ETF	149.11	149.42	149.1	149.1	4638800.0
2007-06-07 17:00:00	SPY	ETF	149.26	149.8895	149.23	149.27	324800.0
2007-06-07 17:30:00	SPY	ETF	149.25	149.29	149.23	149.28	17200.0
2007-06-07 18:00:00	SPY	ETF	149.29	149.29	149.2	149.22	17300.0
2007-06-07 18:30:00	SPY	ETF	149.19	149.23	149.18	149.18	2500.0
2007-06-07 19:00:00	SPY	ETF	149.15	149.15	149.0	149.05	21900.0
2007-06-07 19:30:00	SPY	ETF	149.09	149.27	149.09	149.27	28600.0
2007-06-07 06:00:00	QQQ	ETF	47.09	47.09	47.09	47.09	3000.0
2007-06-07 07:00:00	QQQ	ETF	47.14	47.15	47.05	47.06	118950.0
2007-06-07 07:30:00	QQQ	ETF	47.07	47.1	46.94	46.94	490056.0
2007-06-07 08:00:00	QQQ	ETF	46.96	46.97	46.89	46.95	1408439.0
2007-06-07 08:30:00	QQQ	ETF	46.98	47.01	46.88	46.91	1496680.0
2007-06-07 09:00:00	QQQ	ETF	46.93	46.97	46.89	46.93	1121067.0
2007-06-07 09:30:00	QQQ	ETF	46.91	47.21	46.91	47.15	26030846.0
2007-06-07 10:00:00	QQQ	ETF	47.15	47.21	46.99	47.0305	17670170.0
2007-06-07 10:30:00	QQQ	ETF	47.03	47.17	47.02	47.08	16881261.0
2007-06-07 11:00:00	QQQ	ETF	47.08	47.09	46.79	46.92	23823723.0
2007-06-07 11:30:00	QQQ	ETF	46.92	46.96	46.85	46.87	9540824.0
2007-06-07 12:00:00	QQQ	ETF	46.87	46.97	46.83	46.95	11559928.0
2007-06-07 12:30:00	QQQ	ETF	46.9595	46.97	46.71	46.81	11935715.0
2007-06-07 13:00:00	QQQ	ETF	46.82	46.85	46.64	46.67	11558698.0
2007-06-07 13:30:00	QQQ	ETF	46.6785	46.69	46.38	46.54	21029517.0
2007-06-07 14:00:00	QQQ	ETF	46.54	46.55	46.32	46.4811	10031179.0
2007-06-07 14:30:00	QQQ	ETF	46.48	46.62	46.4	46.5685	12529145.0
2007-06-07 15:00:00	QQQ	ETF	46.56	46.76	46.53	46.58	18402761.0
2007-06-07 15:30:00	QQQ	ETF	46.57	46.66	46.33	46.33	16352514.0

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

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