PREVIEW / etf_30min / 2009-07-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-27.parquet
  size:    228 KB
  rows:    7,638

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-07-27 04:30:00	SPY	ETF	98.3	98.3	98.3	98.3	150.0
2009-07-27 05:00:00	SPY	ETF	98.25	98.25	98.25	98.25	25000.0
2009-07-27 05:30:00	SPY	ETF	98.4	98.5	98.4	98.5	720.0
2009-07-27 06:00:00	SPY	ETF	98.5	98.5	98.5	98.5	6000.0
2009-07-27 06:30:00	SPY	ETF	98.48	98.64	98.48	98.64	10350.0
2009-07-27 07:00:00	SPY	ETF	98.6	98.6	98.28	98.28	92094.0
2009-07-27 07:30:00	SPY	ETF	98.29	98.29	98.16	98.28	568258.0
2009-07-27 08:00:00	SPY	ETF	98.28	98.65	97.89	98.06	860731.0
2009-07-27 08:30:00	SPY	ETF	98.06	98.23	97.95	98.18	746672.0
2009-07-27 09:00:00	SPY	ETF	98.2	98.3	97.83	97.88	1751465.0
2009-07-27 09:30:00	SPY	ETF	97.88	98.09	97.72	97.91	20888539.0
2009-07-27 10:00:00	SPY	ETF	97.91	98.4	97.59	97.59	23702359.0
2009-07-27 10:30:00	SPY	ETF	97.59	97.63	97.34	97.52	12914331.0
2009-07-27 11:00:00	SPY	ETF	97.5183	97.92	97.49	97.85	10509826.0
2009-07-27 11:30:00	SPY	ETF	97.86	98.02	97.71	97.71	7678506.0
2009-07-27 12:00:00	SPY	ETF	97.72	97.86	97.63	97.79	4620107.0
2009-07-27 12:30:00	SPY	ETF	97.79	97.87	97.64	97.79	5318315.0
2009-07-27 13:00:00	SPY	ETF	97.8	97.87	97.54	97.57	6599695.0
2009-07-27 13:30:00	SPY	ETF	97.57	98.0	97.53	97.94	6453295.0
2009-07-27 14:00:00	SPY	ETF	97.95	98.07	97.83	97.95	5940784.0
2009-07-27 14:30:00	SPY	ETF	97.95	98.26	97.93	98.16	10301505.0
2009-07-27 15:00:00	SPY	ETF	98.1683	98.26	97.93	98.06	12223905.0
2009-07-27 15:30:00	SPY	ETF	98.07	98.38	97.86	98.35	14702805.0
2009-07-27 16:00:00	SPY	ETF	98.36	98.44	97.55	98.33	5956406.0
2009-07-27 16:30:00	SPY	ETF	98.31	98.38	98.28	98.34	1145773.0
2009-07-27 17:00:00	SPY	ETF	98.33	98.43	98.33	98.43	280354.0
2009-07-27 17:30:00	SPY	ETF	98.43	98.46	98.43	98.45	56257.0
2009-07-27 18:00:00	SPY	ETF	98.44	98.45	98.25	98.32	199456.0
2009-07-27 18:30:00	SPY	ETF	98.3	98.3	97.99	98.28	82038.0
2009-07-27 19:00:00	SPY	ETF	98.26	98.28	98.22	98.23	10871.0
2009-07-27 19:30:00	SPY	ETF	98.23	98.25	98.22	98.22	31197.0
2009-07-27 04:00:00	QQQ	ETF	39.33	39.33	39.33	39.33	2300.0
2009-07-27 04:30:00	QQQ	ETF	39.38	39.38	39.38	39.38	100.0
2009-07-27 05:00:00	QQQ	ETF	39.3	39.3	39.3	39.3	500.0
2009-07-27 05:30:00	QQQ	ETF	39.45	39.46	39.45	39.45	1100.0
2009-07-27 06:00:00	QQQ	ETF	39.47	39.47	39.44	39.45	500.0
2009-07-27 06:30:00	QQQ	ETF	39.48	39.55	39.48	39.55	15300.0
2009-07-27 07:00:00	QQQ	ETF	39.51	39.53	39.39	39.4	106800.0
2009-07-27 07:30:00	QQQ	ETF	39.39	39.43	39.35	39.43	153369.0
2009-07-27 08:00:00	QQQ	ETF	39.43	39.44	39.27	39.34	285566.0
2009-07-27 08:30:00	QQQ	ETF	39.34	39.37	39.25	39.36	362559.0
2009-07-27 09:00:00	QQQ	ETF	39.36	39.37	39.23	39.29	522977.0
2009-07-27 09:30:00	QQQ	ETF	39.29	39.4	39.142	39.18	14813684.0
2009-07-27 10:00:00	QQQ	ETF	39.19	39.41	38.96	38.989	15934770.0
2009-07-27 10:30:00	QQQ	ETF	38.9802	39.0	38.87	39.0	6945964.0
2009-07-27 11:00:00	QQQ	ETF	38.99	39.18	38.99	39.16	5478709.0
2009-07-27 11:30:00	QQQ	ETF	39.16	39.24	39.09	39.09	3981433.0
2009-07-27 12:00:00	QQQ	ETF	39.1	39.2	39.07	39.1301	2695531.0
2009-07-27 12:30:00	QQQ	ETF	39.14	39.15	39.05	39.1	4213137.0
2009-07-27 13:00:00	QQQ	ETF	39.1099	39.2	39.01	39.03	3519534.0

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

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