PREVIEW / etf_30min / 2008-05-21

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-05-21.parquet
  size:    174 KB
  rows:    5,967

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-21 04:00:00	SPY	ETF	142.14	142.17	142.14	142.17	1700.0
2008-05-21 05:00:00	SPY	ETF	142.25	142.25	142.23	142.23	2200.0
2008-05-21 05:30:00	SPY	ETF	142.25	142.25	142.25	142.25	500.0
2008-05-21 06:00:00	SPY	ETF	141.87	141.87	141.76	141.76	22450.0
2008-05-21 06:30:00	SPY	ETF	141.75	141.82	141.61	141.82	28650.0
2008-05-21 07:00:00	SPY	ETF	141.84	141.91	141.51	141.53	216497.0
2008-05-21 07:30:00	SPY	ETF	141.52	141.66	141.25	141.66	633370.0
2008-05-21 08:00:00	SPY	ETF	141.63	142.26	141.37	141.71	994252.0
2008-05-21 08:30:00	SPY	ETF	141.71	141.77	141.53	141.69	757937.0
2008-05-21 09:00:00	SPY	ETF	141.71	141.83	141.65	141.79	1447730.0
2008-05-21 09:30:00	SPY	ETF	141.81	142.12	141.64	141.69	20423721.0
2008-05-21 10:00:00	SPY	ETF	141.68	141.9	141.5	141.79	16763941.0
2008-05-21 10:30:00	SPY	ETF	141.79	141.8	141.04	141.1	22651069.0
2008-05-21 11:00:00	SPY	ETF	141.09	141.42	140.99	141.36	14347880.0
2008-05-21 11:30:00	SPY	ETF	141.36	141.55	141.16	141.44	8840570.0
2008-05-21 12:00:00	SPY	ETF	141.44	141.47	141.29	141.41	6454999.0
2008-05-21 12:30:00	SPY	ETF	141.42	141.74	141.35	141.545	10731999.0
2008-05-21 13:00:00	SPY	ETF	141.56	141.58	141.0	141.09	9124881.0
2008-05-21 13:30:00	SPY	ETF	141.08	141.34	140.78	140.88	11314086.0
2008-05-21 14:00:00	SPY	ETF	140.89	140.91	139.76	139.93	37097242.0
2008-05-21 14:30:00	SPY	ETF	139.93	140.0	139.0	139.75	27335436.0
2008-05-21 15:00:00	SPY	ETF	139.75	139.96	139.48	139.72	17109052.0
2008-05-21 15:30:00	SPY	ETF	139.72	139.91	139.04	139.3	28455430.0
2008-05-21 16:00:00	SPY	ETF	139.31	142.26	139.22	139.46	7803431.0
2008-05-21 16:30:00	SPY	ETF	139.47	141.5377	139.26	139.46	4736821.0
2008-05-21 17:00:00	SPY	ETF	139.44	139.62	139.42	139.62	1123017.0
2008-05-21 17:30:00	SPY	ETF	139.6	139.6	139.55	139.6	5200.0
2008-05-21 18:00:00	SPY	ETF	139.6	139.6	139.47	139.56	31471.0
2008-05-21 18:30:00	SPY	ETF	139.51	139.54	139.48	139.49	1600.0
2008-05-21 19:00:00	SPY	ETF	139.5	139.5	139.38	139.38	4650.0
2008-05-21 19:30:00	SPY	ETF	139.45	139.47	139.38	139.41	10750.0
2008-05-21 06:30:00	QQQ	ETF	49.3	49.3	49.29	49.29	2600.0
2008-05-21 07:00:00	QQQ	ETF	49.32	49.33	49.23	49.23	58170.0
2008-05-21 07:30:00	QQQ	ETF	49.2	49.22	49.09	49.19	510200.0
2008-05-21 08:00:00	QQQ	ETF	49.19	49.22	49.13	49.2	417121.0
2008-05-21 08:30:00	QQQ	ETF	49.21	49.23	49.16	49.23	229440.0
2008-05-21 09:00:00	QQQ	ETF	49.21	49.31	49.19	49.31	304742.0
2008-05-21 09:30:00	QQQ	ETF	49.31	49.6	49.26	49.33	18049878.0
2008-05-21 10:00:00	QQQ	ETF	49.33	49.49	49.19	49.28	14765673.0
2008-05-21 10:30:00	QQQ	ETF	49.28	49.28	49.0	49.035	17502960.0
2008-05-21 11:00:00	QQQ	ETF	49.0326	49.14	48.92	49.098	14937919.0
2008-05-21 11:30:00	QQQ	ETF	49.09	49.13	48.94	49.08	7998911.0
2008-05-21 12:00:00	QQQ	ETF	49.08	49.17	49.01	49.15	3891478.0
2008-05-21 12:30:00	QQQ	ETF	49.15	49.27	49.07	49.22	6414069.0
2008-05-21 13:00:00	QQQ	ETF	49.22	49.2284	48.93	48.95	4790603.0
2008-05-21 13:30:00	QQQ	ETF	48.95	49.05	48.8	48.8205	7998289.0
2008-05-21 14:00:00	QQQ	ETF	48.82	48.8288	48.22	48.37	26847517.0
2008-05-21 14:30:00	QQQ	ETF	48.37	48.37	48.12	48.33	18055779.0
2008-05-21 15:00:00	QQQ	ETF	48.33	48.44	48.18	48.35	14123756.0
2008-05-21 15:30:00	QQQ	ETF	48.35	48.39	48.02	48.1999	21836551.0

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

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