PREVIEW / etf_30min / 2009-04-07

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-07.parquet
  size:    207 KB
  rows:    7,008

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-04-07 04:00:00	SPY	ETF	83.11	83.11	83.11	83.11	200.0
2009-04-07 04:30:00	SPY	ETF	83.01	83.01	82.35	82.43	16013.0
2009-04-07 05:00:00	SPY	ETF	82.48	82.67	82.48	82.67	2600.0
2009-04-07 05:30:00	SPY	ETF	82.58	82.6	82.58	82.6	300.0
2009-04-07 06:00:00	SPY	ETF	82.55	82.55	82.39	82.48	35001.0
2009-04-07 06:30:00	SPY	ETF	82.48	82.51	82.0	82.03	89400.0
2009-04-07 07:00:00	SPY	ETF	82.09	82.23	82.06	82.18	242663.0
2009-04-07 07:30:00	SPY	ETF	82.21	82.31	81.8	81.98	634814.0
2009-04-07 08:00:00	SPY	ETF	81.99	83.3	81.96	82.07	1073168.0
2009-04-07 08:30:00	SPY	ETF	82.08	82.29	82.07	82.14	653208.0
2009-04-07 09:00:00	SPY	ETF	82.14	82.27	82.0	82.25	1773658.0
2009-04-07 09:30:00	SPY	ETF	82.25	82.26	81.67	81.97	32019556.0
2009-04-07 10:00:00	SPY	ETF	81.96	82.24	81.73	82.23	24023068.0
2009-04-07 10:30:00	SPY	ETF	82.2301	82.65	82.18	82.38	24345542.0
2009-04-07 11:00:00	SPY	ETF	82.39	82.55	82.23	82.3	16761831.0
2009-04-07 11:30:00	SPY	ETF	82.31	82.55	82.06	82.13	17150362.0
2009-04-07 12:00:00	SPY	ETF	82.13	82.46	82.07	82.12	12705637.0
2009-04-07 12:30:00	SPY	ETF	82.12	82.35	82.03	82.31	10536921.0
2009-04-07 13:00:00	SPY	ETF	82.31	82.35	81.72	81.79	14189593.0
2009-04-07 13:30:00	SPY	ETF	81.79	82.0	81.56	81.73	14020112.0
2009-04-07 14:00:00	SPY	ETF	81.74	81.87	81.52	81.74	9924058.0
2009-04-07 14:30:00	SPY	ETF	81.75	81.86	81.51	81.84	12993624.0
2009-04-07 15:00:00	SPY	ETF	81.84	82.2	81.62	81.88	17541040.0
2009-04-07 15:30:00	SPY	ETF	81.87	82.37	81.56	81.56	30157117.0
2009-04-07 16:00:00	SPY	ETF	81.58	82.25	81.55	81.96	9668191.0
2009-04-07 16:30:00	SPY	ETF	81.94	82.0	81.75	81.75	1171309.0
2009-04-07 17:00:00	SPY	ETF	81.77	81.88	81.69	81.85	2865054.0
2009-04-07 17:30:00	SPY	ETF	81.8	81.87	81.77	81.87	40240.0
2009-04-07 18:00:00	SPY	ETF	81.85	81.89	81.77	81.84	31551.0
2009-04-07 18:30:00	SPY	ETF	81.83	81.86	81.8	81.85	10392.0
2009-04-07 19:00:00	SPY	ETF	81.85	81.88	81.84	81.87	15271.0
2009-04-07 19:30:00	SPY	ETF	81.85	82.0	81.85	81.94	81517.0
2009-04-07 04:30:00	QQQ	ETF	32.04	32.05	31.99	32.01	30000.0
2009-04-07 05:00:00	QQQ	ETF	31.96	31.96	31.93	31.93	17200.0
2009-04-07 05:30:00	QQQ	ETF	31.96	31.96	31.96	31.96	2000.0
2009-04-07 06:30:00	QQQ	ETF	31.95	31.95	31.8	31.8	53000.0
2009-04-07 07:00:00	QQQ	ETF	31.77	31.86	31.77	31.82	146219.0
2009-04-07 07:30:00	QQQ	ETF	31.87	31.9	31.73	31.79	185201.0
2009-04-07 08:00:00	QQQ	ETF	31.78	32.2	31.78	31.88	214677.0
2009-04-07 08:30:00	QQQ	ETF	31.89	31.97	31.89	31.91	431581.0
2009-04-07 09:00:00	QQQ	ETF	31.91	31.92	31.83	31.92	852296.0
2009-04-07 09:30:00	QQQ	ETF	31.91	31.92	31.51	31.62	16687072.0
2009-04-07 10:00:00	QQQ	ETF	31.62	31.74	31.51	31.74	11917936.0
2009-04-07 10:30:00	QQQ	ETF	31.74	31.83	31.61	31.75	10465161.0
2009-04-07 11:00:00	QQQ	ETF	31.74	31.78	31.63	31.68	5761429.0
2009-04-07 11:30:00	QQQ	ETF	31.67	31.76	31.56	31.61	6681392.0
2009-04-07 12:00:00	QQQ	ETF	31.6	31.68	31.56	31.58	6545633.0
2009-04-07 12:30:00	QQQ	ETF	31.58	31.67	31.55	31.64	6935000.0
2009-04-07 13:00:00	QQQ	ETF	31.638	31.638	31.26	31.3	11912599.0
2009-04-07 13:30:00	QQQ	ETF	31.3	31.3625	31.21	31.34	8782079.0

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

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