PREVIEW / etf_30min / 2008-05-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-15.parquet
  size:    166 KB
  rows:    5,698

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
2008-05-15 05:30:00	SPY	ETF	141.12	141.12	141.12	141.12	6000.0
2008-05-15 06:00:00	SPY	ETF	141.2	141.21	141.11	141.11	331024.0
2008-05-15 06:30:00	SPY	ETF	141.1	141.1	141.07	141.07	10500.0
2008-05-15 07:00:00	SPY	ETF	141.05	141.17	140.98	141.15	256170.0
2008-05-15 07:30:00	SPY	ETF	141.15	141.32	141.11	141.29	423406.0
2008-05-15 08:00:00	SPY	ETF	141.29	141.46	141.0	141.42	1635913.0
2008-05-15 08:30:00	SPY	ETF	141.42	141.42	140.85	141.22	1391072.0
2008-05-15 09:00:00	SPY	ETF	141.25	141.33	141.03	141.03	1521504.0
2008-05-15 09:30:00	SPY	ETF	141.04	141.2	140.83	141.19	16124687.0
2008-05-15 10:00:00	SPY	ETF	141.191	141.37	140.87	141.275	18333528.0
2008-05-15 10:30:00	SPY	ETF	141.27	141.43	141.1	141.32	8366549.0
2008-05-15 11:00:00	SPY	ETF	141.32	141.53	141.13	141.21	6837589.0
2008-05-15 11:30:00	SPY	ETF	141.21	141.33	141.03	141.29	9039419.0
2008-05-15 12:00:00	SPY	ETF	141.29	141.79	141.2	141.67	11756930.0
2008-05-15 12:30:00	SPY	ETF	141.67	141.92	141.62	141.71	12323762.0
2008-05-15 13:00:00	SPY	ETF	141.71	141.9	141.65	141.72	5908849.0
2008-05-15 13:30:00	SPY	ETF	141.72	141.82	141.54	141.69	7191105.0
2008-05-15 14:00:00	SPY	ETF	141.68	141.98	141.61	141.66	11367987.0
2008-05-15 14:30:00	SPY	ETF	141.65	142.06	141.62	141.92	9003452.0
2008-05-15 15:00:00	SPY	ETF	141.91	142.1	141.805	142.041	11969478.0
2008-05-15 15:30:00	SPY	ETF	142.05	142.63	141.89	142.55	25082940.0
2008-05-15 16:00:00	SPY	ETF	142.55	142.95	141.048	142.56	4980962.0
2008-05-15 16:30:00	SPY	ETF	142.55	142.56	142.4	142.4	494261.0
2008-05-15 17:00:00	SPY	ETF	142.41	142.54	140.9325	142.52	411991.0
2008-05-15 17:30:00	SPY	ETF	142.45	142.45	142.45	142.45	200.0
2008-05-15 18:00:00	SPY	ETF	142.44	142.46	142.41	142.43	2800.0
2008-05-15 18:30:00	SPY	ETF	142.44	142.44	142.26	142.26	15679.0
2008-05-15 19:00:00	SPY	ETF	142.28	142.31	142.27	142.28	4000.0
2008-05-15 19:30:00	SPY	ETF	142.3	142.33	142.28	142.33	3550.0
2008-05-15 06:00:00	QQQ	ETF	49.22	49.22	49.22	49.22	1000.0
2008-05-15 06:30:00	QQQ	ETF	49.19	49.19	49.16	49.16	2800.0
2008-05-15 07:00:00	QQQ	ETF	49.17	49.19	49.13	49.19	38000.0
2008-05-15 07:30:00	QQQ	ETF	49.19	49.22	49.17	49.22	141928.0
2008-05-15 08:00:00	QQQ	ETF	49.23	49.26	49.21	49.25	438909.0
2008-05-15 08:30:00	QQQ	ETF	49.22	49.26	49.15	49.24	1391246.0
2008-05-15 09:00:00	QQQ	ETF	49.25	49.26	49.08	49.12	1274609.0
2008-05-15 09:30:00	QQQ	ETF	49.11	49.28	48.98	49.24	13841109.0
2008-05-15 10:00:00	QQQ	ETF	49.24	49.35	49.09	49.29	13143581.0
2008-05-15 10:30:00	QQQ	ETF	49.28	49.4	49.18	49.3299	8392695.0
2008-05-15 11:00:00	QQQ	ETF	49.33	49.471	49.21	49.27	8687855.0
2008-05-15 11:30:00	QQQ	ETF	49.27	49.42	49.25	49.41	9231474.0
2008-05-15 12:00:00	QQQ	ETF	49.41	49.67	49.39	49.65	13507096.0
2008-05-15 12:30:00	QQQ	ETF	49.65	49.78	49.61	49.69	9159314.0
2008-05-15 13:00:00	QQQ	ETF	49.68	49.8	49.65	49.7	6508362.0
2008-05-15 13:30:00	QQQ	ETF	49.71	49.76	49.63	49.7	6207632.0
2008-05-15 14:00:00	QQQ	ETF	49.71	49.81	49.57	49.5801	11249319.0
2008-05-15 14:30:00	QQQ	ETF	49.59	49.77	49.58	49.712	8634877.0
2008-05-15 15:00:00	QQQ	ETF	49.7125	49.85	49.67	49.83	9384921.0
2008-05-15 15:30:00	QQQ	ETF	49.83	50.02	49.745	49.98	16526704.0
2008-05-15 16:00:00	QQQ	ETF	49.98	50.08	49.7	50.03	6144285.0

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

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