PREVIEW / etf_30min / 2009-04-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-13.parquet
  size:    212 KB
  rows:    7,003

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-13 04:00:00	SPY	ETF	85.13	85.13	85.06	85.06	1547.0
2009-04-13 04:30:00	SPY	ETF	85.06	85.06	85.05	85.05	367.0
2009-04-13 05:00:00	SPY	ETF	85.0	85.0	84.96	84.99	1826.0
2009-04-13 05:30:00	SPY	ETF	85.01	85.01	84.88	84.88	1200.0
2009-04-13 06:00:00	SPY	ETF	84.93	84.93	84.9	84.91	5507.0
2009-04-13 06:30:00	SPY	ETF	84.93	85.08	84.93	85.02	8250.0
2009-04-13 07:00:00	SPY	ETF	85.05	85.22	85.03	85.05	137196.0
2009-04-13 07:30:00	SPY	ETF	85.08	85.09	84.93	84.97	285482.0
2009-04-13 08:00:00	SPY	ETF	84.98	85.19	84.96	85.16	373506.0
2009-04-13 08:30:00	SPY	ETF	85.16	85.25	85.13	85.16	721995.0
2009-04-13 09:00:00	SPY	ETF	85.17	85.17	84.89	84.92	1952422.0
2009-04-13 09:30:00	SPY	ETF	84.92	85.04	84.58	84.7	20631691.0
2009-04-13 10:00:00	SPY	ETF	84.7	85.49	84.66	85.32	16733070.0
2009-04-13 10:30:00	SPY	ETF	85.31	85.3333	84.97	85.09	16174260.0
2009-04-13 11:00:00	SPY	ETF	85.09	85.23	84.8	85.15	11406042.0
2009-04-13 11:30:00	SPY	ETF	85.151	85.18	84.77	84.98	12471006.0
2009-04-13 12:00:00	SPY	ETF	84.98	85.365	84.94	85.17	7879608.0
2009-04-13 12:30:00	SPY	ETF	85.17	85.45	85.17	85.4	5557961.0
2009-04-13 13:00:00	SPY	ETF	85.4	85.73	85.17	85.59	9572193.0
2009-04-13 13:30:00	SPY	ETF	85.5909	85.85	85.5909	85.8301	11481651.0
2009-04-13 14:00:00	SPY	ETF	85.84	85.9	85.47	85.6	11302085.0
2009-04-13 14:30:00	SPY	ETF	85.6	85.84	85.52	85.55	12628598.0
2009-04-13 15:00:00	SPY	ETF	85.55	86.29	85.38	86.19	23656998.0
2009-04-13 15:30:00	SPY	ETF	86.18	86.54	85.1	85.85	33831093.0
2009-04-13 16:00:00	SPY	ETF	85.84	86.13	85.67	85.77	12777911.0
2009-04-13 16:30:00	SPY	ETF	85.77	86.0	85.0	85.95	2182623.0
2009-04-13 17:00:00	SPY	ETF	85.93	85.93	85.84	85.87	80360.0
2009-04-13 17:30:00	SPY	ETF	85.9	85.9	85.83	85.83	243820.0
2009-04-13 18:00:00	SPY	ETF	85.8	85.83	85.7	85.7	72641.0
2009-04-13 18:30:00	SPY	ETF	85.71	85.71	85.65	85.66	38826.0
2009-04-13 19:00:00	SPY	ETF	85.66	85.72	85.66	85.71	4773.0
2009-04-13 19:30:00	SPY	ETF	85.71	85.81	85.64	85.79	14619.0
2009-04-13 04:00:00	QQQ	ETF	32.9	32.9	32.74	32.74	600.0
2009-04-13 05:30:00	QQQ	ETF	32.65	32.65	32.65	32.65	900.0
2009-04-13 06:00:00	QQQ	ETF	32.72	32.72	32.72	32.72	100.0
2009-04-13 06:30:00	QQQ	ETF	32.75	32.75	32.75	32.75	200.0
2009-04-13 07:00:00	QQQ	ETF	32.75	32.8	32.74	32.75	179683.0
2009-04-13 07:30:00	QQQ	ETF	32.74	32.74	32.69	32.71	162167.0
2009-04-13 08:00:00	QQQ	ETF	32.72	32.83	32.7	32.8	407122.0
2009-04-13 08:30:00	QQQ	ETF	32.8	32.81	32.76	32.79	102450.0
2009-04-13 09:00:00	QQQ	ETF	32.78	32.79	32.74	32.79	386012.0
2009-04-13 09:30:00	QQQ	ETF	32.8	32.87	32.66	32.72	9227279.0
2009-04-13 10:00:00	QQQ	ETF	32.72	32.87	32.7	32.81	7576449.0
2009-04-13 10:30:00	QQQ	ETF	32.82	32.82	32.63	32.6499	8507769.0
2009-04-13 11:00:00	QQQ	ETF	32.64	32.7	32.53	32.66	8904495.0
2009-04-13 11:30:00	QQQ	ETF	32.66	32.67	32.56	32.63	5002468.0
2009-04-13 12:00:00	QQQ	ETF	32.64	32.72	32.63	32.6876	2802969.0
2009-04-13 12:30:00	QQQ	ETF	32.6803	32.77	32.68	32.76	2189653.0
2009-04-13 13:00:00	QQQ	ETF	32.76	32.88	32.69	32.83	4212848.0
2009-04-13 13:30:00	QQQ	ETF	32.83	32.87	32.8	32.86	4441096.0

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

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